Forum Discussion
Real-time updates in PowerBI without pressing the refresh button (Without Powerbi Premium Per User)
- 2 years ago
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.
- 2 years ago
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
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?
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
- efjw2 years ago
Helper I
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?
- frithjof_v2 years ago
Community Champion
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.
- efjw2 years ago
Helper I
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