Solved: Re: Customer requires rapid refresh rate

PowerBI-ELM · ‎06-15-2022

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,

GilbertQ · ‎06-15-2022

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

View solution in original post

Hariharan_R · ‎06-16-2022

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