cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
justinh Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
MichaelOgaz Frequent Visitor
Frequent Visitor

Re: Disable Refresh Upon Publish?

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

View solution in original post

4 REPLIES 4
v-lid-msft Super Contributor
Super Contributor

Re: Disable Refresh Upon Publish?

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.

 

12.PNG

 

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 Regular Visitor
Regular Visitor

Re: Disable Refresh Upon Publish?

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? 

2019-10-14 09_39_16-Window.png

 

MichaelOgaz Frequent Visitor
Frequent Visitor

Re: Disable Refresh Upon Publish?

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

View solution in original post

justinh Regular Visitor
Regular Visitor

Re: Disable Refresh Upon Publish?

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. 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 142 members 1,586 guests
Please welcome our newest community members: