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
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.
Community ChampionThanks 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.