Forum Discussion
Helper IReal-time updates in PowerBI without pressing the refresh button (Without Powerbi Premium Per User)
If you are on a Pro workspace, then the recommended way is to create a streaming semantic model and then create a dashboard (not report) using data from that streaming semantic model.
Another option (not as smooth updates as the first option) is to create a Push semantic model, create a report on top of that Push semantic model, and then pin some tiles from the report into a dashboard.
The way I understand the docs, the only way to get automatic updates in a Pro workspace, is to use the dashboard functionality.
frithjof_v I tried to use my streaming dataset to create a report in powerbi and pin the visuals in my dashboard and the real time updates happen! I think this works too 🙂 thanks so much for your help
Helper Ifrithjof_v Thanks! Could you recommend ways that I can implement a real-time dashboard instead of the above method? I am currently looking into importing my data from PostgreSQL into SQL Server and use an SQL server to get data instead. Would this be feasible?
Community ChampionIf you are on a Pro workspace, then the recommended way is to create a streaming semantic model and then create a dashboard (not report) using data from that streaming semantic model.
Another option (not as smooth updates as the first option) is to create a Push semantic model, create a report on top of that Push semantic model, and then pin some tiles from the report into a dashboard.
The way I understand the docs, the only way to get automatic updates in a Pro workspace, is to use the dashboard functionality.
- efjw
frithjof_v I tried to use my streaming dataset to create a report in powerbi and pin the visuals in my dashboard and the real time updates happen! I think this works too 🙂 thanks so much for your help
Hi efjw and frithjof_v,
I have some follow-up questions regarding the recommended solution.
It has been announced that:
"Creation of streaming models remains enabled until October 31st, 2027. After that date, the creation of new real-time semantic models will no longer be supported, including push semantic models, streaming semantic models, PubNub streaming semantic models, and streaming data tiles."As I understand it, the new solution relies on Fabric's Real-time Dashboard connecting to an event stream and event house to visualize real-time data. However, the issue lies in the UI—the functionality is quite limited in terms of customization.
Since real-time stream semantic models can no longer be used, it seems that Power BI dashboards cannot support real-time data without manual refreshes (clicking 'refresh').
Have you perhaps looked into any functionality within Fabric that supports real-time data based on Power BI visuals (reports or dashboard tiles) without requiring Power BI Premium Per User (with the Auto Page Refresh feature)?
- frithjof_v
"without requiring Power BI Premium Per User (with the Auto Page Refresh feature"
I don't think the Auto Page Refresh feature requires PPU license if you are on a Fabric capacity. On a Fabric capacity, you have access to Power BI Premium features.
If you have access to a Fabric trial capacity, or a purchased Fabric trial capacity, you can test it.
Keep in mind the auto page refresh can require a bit of compute resources, so it's good to test in a Fabric trial capacity if you have access to one, and verify the consumption in the Capacity Metrics App.
Anyway, great question! I think the reflections and question makes great sense. I'm also curious about this topic and I don't have all the answers to it.
You could consider posting the question as a new post here in the community, or over at the Fabric subreddit https://www.reddit.com/r/MicrosoftFabric/s/OmbW2bA2SC
Thank you for your quick answer! For real-time scenarios, the Auto Page Refresh feature typically needs to be set to "per second" or utilize "change detection." Unfortunately, it seems that the 5-minute auto refresh interval is the limit on the Pro license. Would you agree with that? 🙂
I did this post - I will hope to get some input there in the nearest future: Real-Time Intelligence: How to Achieve Real-Time P... - Microsoft Fabric Community