Disable Refresh Upon Publish?

[justinh]

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 people to the new RLS roles that I created until the refresh is complete. In the case of my dataset, this is adding an extra 45-60 minutes to the process and seems completely unneeded. 

Is there any way to prevent the Service from refreshing the dataset when published? 

Thank you. 

[MichaelOgaz · Accepted solution]

@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. 

[justinh]

Thank you @MichaelOgaz

This work-around is exactly what I was looking for.

It would be nice if this issue didn't exist, but so long as it does, I'm glad there is a way around it.

Thanks. 

[v-lid-msft]

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]

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?