Forum Discussion
Direct Query Model with a Scheduled Refresh (can't disable)
I am creating some proof of concept reports for my company to show what PBI can do. Long story short, no admin support, just me with a download of PBI desktop and the ability to publish to say My Workspace. I have used PBI before, but this is new for my current company.
Anyway, I have a direct query report (2 views, both confirmed direct query). The semantic model created from this report is published to My Workspace. Somehow, this direct query model has a scheduled refresh happening despite having no gateway connetions at all (and direct query). Runs about every hour, and is over within literally one second. Did some digging, and it might be a 'metadata refresh' happening.
All the google fix suggestions leads to going into the model settings and going to Refresh and disable. Makes perfect sense. However, Refresh is greyed out as it is a Direct Query model. No harm is being done, but I want to figure it out. If Refresh is greyed out, how can I disable this refresh?
Thanks
What you are seeing is not a scheduled data refresh that you set up. For DirectQuery semantic models, Power BI Service runs its own automatic metadata and cache refresh on the platform side, which is what shows in your refresh history as a one second event roughly every hour.
That is why the Refresh option in the model settings is greyed out. DirectQuery models do not cache data, so there is no scheduled refresh for you to configure or disable. It is platform managed, not a user setting, and it does not pull data from your source or count against refresh limits, so you can safely ignore it.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai Karmani
3 Replies
What you are seeing is not a scheduled data refresh that you set up. For DirectQuery semantic models, Power BI Service runs its own automatic metadata and cache refresh on the platform side, which is what shows in your refresh history as a one second event roughly every hour.
That is why the Refresh option in the model settings is greyed out. DirectQuery models do not cache data, so there is no scheduled refresh for you to configure or disable. It is platform managed, not a user setting, and it does not pull data from your source or count against refresh limits, so you can safely ignore it.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai KarmaniHi bhorsey
Refresh you are seeing might be of schema refresh from service instead data refresh. Since Direct Query datasets will not import data, Refresh settings are disabled and cannot be turned off. These quick refresh events are normal keeping metadata synchronized
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
Hi bhorsey ,
In the refresh history which refresh type you can see? It should something like
schedule refresh on the power bi service
Also, you can't disable the metadata refresh/sync by toggle any schedule refresh radio button. You can ignore it and it will not crashing anything. If any other refresh history you can see let us know.
Hope this helps, please consider as an accepted solution if helps or give some kudos.
