Forum Discussion
real time data refresh use excel
hi experts, I want to create a dashboard in power bi that required to be able to refresh data in real time, and the data the pbix file using is come from excel, for example, whenever I create undate my data in the excel, and the power bi published should be updated either, and I want to make such a POC without paying the money for example microsoft product license,
do you have solution to help me achieve this?
Thank you.
2 Replies
oakfootballclub , On Power bi desktop you can refresh it and get the new data. On Power BI Service you can only refresh 8 times daily if you have a pro license and 48 times with PPU or premium
You can try 60 days free Microsoft Fabric trial, there you can refresh as per need
Microsoft Fabric: Step-by-Step Guide to Starting Your Free Trial- https://youtu.be/8kIMHmkQ9m4
Maybe you can consider the Push semantic model:
With a push semantic model, data is pushed into the Power BI service. When the semantic model is created, the Power BI service automatically creates a new database in the service to store the data.
Because there's an underlying database that stores the data as it arrives, you can create reports with the data. These reports and their visuals are just like any other report visuals. You can use all of Power BI's report building features, such as Power BI visuals, data alerts, and pinned dashboard tiles.
Once you create a report using the push semantic model, you can pin any of the report visuals to a dashboard. On that dashboard, visuals update in real time whenever the data is updated. Within the Power BI service, the dashboard triggers a tile refresh every time new data is received.
Link for your reference:
Real-time streaming in Power BI - Power BI | Microsoft Learn
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
