Forum Discussion
Power BI Service Refresh
Hi,
I want to refresh my dataset in Power BI service every second so that it can update the dashboard whenever a chnage is made in the databse. Somehow, I can scheduke the refresh on desktop and it works but the same thing does not work on Power BI service.
I tried using live streaming, but in my case it did not work. Because instead of. atile, I need a table with certain infromation which needs to be updated every second.
Hope somebody can help me.
5 Replies
Hi Anonymous ,
If the workspace is shared workspace, the minimum automatic page refresh interval can only be set as 30 seconds. So, when you publish the report on Power BI Service, the refresh interval will be changed to 30 seconds.
If the workspace is premium workspace, the minimum automatic page refresh interval can only be set as what your admin has set. So, you need to ask your admin to set the minimum interval as 1 seconds.
This is because there are some restrictions on automatic page refresh intervals in Power BI Service:
Shared workspaces - For regular workspaces (workspaces that are not part of a Premium capacity), automatic page refresh has a minimum interval of 30 minutes (the lowest interval allowed).Premium workspaces - Automatic page refresh availability in Premium workspaces will depend on the workload settings your premium administrator has set up for the Power BI Premium capacity. There are two variables that might affect your ability to set up automatic page refresh:- Feature on/off: if your capacity administrator has decided to disable the feature, you won't be able to set up any type of page refresh in your published report.
- Minimum refresh interval: when enabling the feature, your capacity administrator must set up a minimum refresh interval. If your interval is lower than the minimum, the Power BI service overrides your interval to respect the minimum interval set by your capacity administrator.
For example, in the below picture, Automatic page refresh function is opened by admin. And the minimum refresh interval is set as 5 seconds. So, if the time interval you set on your desktop is less than 5 seconds, it will become 5 seconds once the report is published to the service.
I found this video and refer to it, the minimum report refresh interval can be set to 2 seconds.
I didn't find other workarounds currently.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
My understanding is that what you did is setting Automatic page refresh on Power BI Desktop. And then, you published the report to Power BI Service. Right?
What's your data source? If they are on-premises, you need to use a gateway.
1. You can refer this document to deploy a gateway for Power BI: https://docs.microsoft.com/en-us/power-bi/service-gateway-deployment-guidance.
2. And these document will help you to manage data sources:
https://docs.microsoft.com/en-us/power-bi/service-gateway-data-sources;
https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql.
Then, the automatic page refresh will work in Power BI Service.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
