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
Community Champion"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
- frithjof_v
Is your semantic model in a Fabric workspace or a Pro workspace?
Is your semantic model using DirectQuery, Direct Lake or Import mode?
Hi frithjof_v
It is in a Fabric Workspace using the Real time Intelligence functionalities (Eventstream > EventHouse > KQL database) - Directly from the KQL database, I have then created the PowerBi report and the Semantic model, which automatically connect with Direct Query.- frithjof_v
Thanks for sharing! I thought that setup would be able to use Auto Page Refresh, because:
- it's in a Fabric workspace (allows Premium features to be used)
- it uses DirectQuery
Do you know if the capacity admin has enabled or disabled the auto page refresh feature?
Hi again frithjof_v ,
Yes, I think we have identified the issue. We only have the Fabric Trial capacity, and I am not sure if I am a Capacity Admin. The issue might be that the 'auto page refresh' setting cannot be changed to 1 second when we are only using a Trial.
Currently, we are using Power BI Pro licenses along with real-time streaming dataset functionalities to create Power BI reports, real-time dashboards, and share content with other Pro users. Our pricing model is based on the cost of Pro licenses per user.
With the retirement of the real-time streaming feature, Fabric Real-Time Intelligence functionalities will replace it. This change requires us to upgrade to a Fabric capacity, which will likely make the solution more expensive.
I have a few questions I’m trying to clarify:
- When we transition to a full Fabric Capacity, will the settings allow us to change the auto page refresh interval to 1 second?
- From what I understand, users will no longer need Pro licenses, as Fabric capacity would enable sharing content with free users. However, it seems Fabric capacity itself would be more expensive. Does that sound correct?
- If that’s the case, is upgrading to Fabric Capacity the only way to continue using real-time features in Power BI?
😊
- frithjof_v
1. I think yes, but I'm not 100% sure. It's been a while since I tested it.
2. On F64 or larger capacity, the report readers don't need Pro license. They can have Free license. Report developers still need Pro license.
On capacities smaller than F64, all Power BI users (devs and readers) need Pro license.
3. That's an interesting question. I think so.