Forum Discussion
Helper ICustomer requires rapid refresh rate
Hello,
I am developing a set of Power BI reports which can graph certain process KPIs in an industrial situation. They have a SQL database which collects temperatures, flow rates, preassures and sometimes the values change every few seconds. They would like to see a report which updates on a short schedule. (Maybe every minute or in some cases every 30 seconds)
I have been spending the day trying to figure out how to speed up the refresh rate. I started the report in the Desktop Version and published it to the trial version of the PowerBI service. When I edit the report I can set the refresh rate to just a few seconds, but it says "Enabled by your admin - Admin interval 30 minutes"
In the admin portal I can set Premium Per User to a much smaller iterval but I don't know if is doing anything.
Can someone suggest what needs to be done to enable a more rapid refresh rate of the data coming in to the report?
Thanks,
Hi PowerBI-ELM
You would need to use Power BI Premium or Premium Per User with a higher refresh rate.
Here are details on how to achieve this
Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs
Hi,
I am sure you are using Direct Query mode option to SQL Server tables. If you do the changes in PPU side to minimum refresh interval then ensure you set the same refresh intervel on the report page setup. Also make sure your workspace is a PPU workspace not Pro workspace.
Test the report in Power BI desktop and make sure you are getting the changes in the report and then publish it to service.
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
4 Replies
- GilbertQ
Super User
Hi PowerBI-ELM
You would need to use Power BI Premium or Premium Per User with a higher refresh rate.
Here are details on how to achieve this
Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs
- Hariharan_R
Solution Sage
Hi,
I am sure you are using Direct Query mode option to SQL Server tables. If you do the changes in PPU side to minimum refresh interval then ensure you set the same refresh intervel on the report page setup. Also make sure your workspace is a PPU workspace not Pro workspace.
Test the report in Power BI desktop and make sure you are getting the changes in the report and then publish it to service.
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
PowerBI-ELMThanks, I did not know that there were diffrent types of workspaces
- PowerBI-ELM
Thanks,
I wish I could mark two answers as the solution.