Forum Discussion

justinh's avatar
justinh
Icon for Advocate IV rankAdvocate IV
6 years ago
Solved

Disable Refresh Upon Publish?

When I refresh a dataset in Desktop, make some changes like adding RLS roles, and then publish to the Service, the Service then does another refresh on the dataset. This prevents me from adding peopl...
Need Help
Tips and Tricks
  • MichaelOgaz's avatar
    MichaelOgaz
    6 years ago

    justinh 

    If you have scheduled refresh enabled for your dataset in the PowerBI service then a refresh will be run for your dataset every time you re-publish it from PowerBI Desktop. They way I avoid this is by disabling the scheduled refresh, publish my dataset then re-enable the scheduled refresh. 

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi justinh ,

 

Do  you mean the OneDrive on demand refresh  in refresh history after your fininsh published your pbix file? If you are using Import Mode, when you publish your pbix file, it will upload all the data (visual, layout, data, qurey, RLS roles) into your service and replace the old, it will start when you start publish your pbix file, and end when the publish task in power bi desktop finished.

 

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

justinh's avatar
justinh
Icon for Advocate IV rankAdvocate IV
6 years ago

I do have some data in my dataset that originates from Onedrive, so that may be the cause of the refresh when published. The refresh takes 30 minutes and includes a full refresh from our on premise databases, not just a quick refresh of Onedrive data. It appears that the OneDrive refresh may trigger a full refresh when published. Is that the case?