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 I am currently using the PowerBI Pro free trial. Will I no longer have the ability to create real-time dashboards via the current method mentioned above when my trial ends? Thanks!
Community ChampionAre you using dashboards or reports?
Are you using Streaming semantic model or Push semantic model or DirectQuery?
According to the docs (links in the previous comment), there are some differences between using dashboard vs. report.
Please read through these docs.
I think at least if you use Streaming semantic model and create dashboards tiles (not report, and not Power BI desktop) then it should be possible to get automatic refresh.
I think also if you create a Push semantic model, then create a report, and then pin a report visual to a dashboard, it should be automatically refreshed.
- efjw
frithjof_v I am looking into using a report for my real-time streaming dataset because I want to incorporate features like filtering. However, I do not see the real-time updating when I publish my report made using a streaming dataset. Does PowerBI not allow me to create a real-time chart using a report?
- frithjof_v
According to the docs, it should not be possible to create a report based on a Streaming semantic model. But you could create a dashboard.
That's why I am thinking you are actually using a Push semantic model, because, as you say, you are able to create a report.
If you are on pro license, I think you can only get automatic refresh in a dashboard (not in a report). See also previous comment.
Ref. also
- efjw
frithjof_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?