Power BI Report vs Analysis Website
Nowadays people are confused to choose Power BI Report or Analysis website When they have data and want to analyse it
Let’s see first how it works. then will explain situations.
How Power BI Works
When the Report creator does a manual/schedule refresh, Data will be updated from the source to Power BI DB.
The end user can’t update data from the source to power BI DB.
Once Power BI DB is updated, the End user can do a refresh report and can see data from power BI DB.
How Website Works
Here Data will be collected from anywhere and stored in DB.
Then Create APIs and UI for the same. When the End user does refresh the page, it automatically website fetches the latest data from DB.
In the same way, the End user can store information in DB through API.
In which situation should I choose the Power BI Report
When you have less data, you want just load, create and see the report
When you don’t want to see the latest data immediately, Through schedule/Manual refresh by report creator you can get the data.
When you have a different source and don’t want to spend much time and money, then you can load and can make reports in Power BI.
When you check data monthly/weekly once, then Power BI is a good option you put schedule refresh monthly/weekly once, then you can see report.
Here you just learn how Power BI works enough to make a report.
In which situation should I choose the Analysis website
When you want you want to see dynamic data whenever you want, you must choose the Analysis website. Because the website has a refresh option to see the latest data as well as we can use a socket connection to get the latest data.
When you want to collect data from users and do analysis, then go for the website.
Here you have to learn multiple technologies(Javascript, PHP, HTML, CSS) to build a website
Based on your need, choose wisely