cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Support Team
Community Support Team

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.

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

Highlighted
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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors