Forum Discussion
Solved
Power Bi Service Auto refresh
Hi, I've set up auto refresh page in Power Bi desktop and it works great, but when I open the report in the Power Bi service it doesn't work. the storage mode is Direct Query and on premises dat...
- Please have a look at this page, because there are certain limitations to page refresh in the service:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#automatic-page-refresh-in-the-power-bi-service
For example, for a regular workspace (in shared capacity) automatic page refresh has a minimum interval of 30 minutes.
For a Premium capacity workspace it depends on the settings in the Admin portal your Power BI Service Admin set.
This surely works with a pro license.
For the refresh to work (also with DirectQuery), you need an entry in the Gateway to the datasource, and then configure your dataset settings in the serivce to use that entry. Did you do both those things also?
For the refresh to work (also with DirectQuery), you need an entry in the Gateway to the datasource, and then configure your dataset settings in the serivce to use that entry. Did you do both those things also?
Hi nickyvv
I set up the on premises data gateway and connect it to the data source.
Is that not enough?
If you can send me a screenshot it would be great
BR,
Alon
- Please have a look at this page, because there are certain limitations to page refresh in the service:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#automatic-page-refresh-in-the-power-bi-service
For example, for a regular workspace (in shared capacity) automatic page refresh has a minimum interval of 30 minutes.
For a Premium capacity workspace it depends on the settings in the Admin portal your Power BI Service Admin set.
