Forum Discussion

bhorsey's avatar
bhorsey
Regular Visitor
2 months ago
Solved

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 Wo...
Need Help
  • Shai_Karmani's avatar
    Shai_Karmani
    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

     

    Let's connect in LinkedIn

Lodha_Jaydeep's avatar
Lodha_Jaydeep
Solution Sage
2 months ago

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.