Forum Discussion
Direct Query Model with a Scheduled Refresh (can't disable)
- 2 months ago
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
Hi 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