cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

How to restrict data refresh for a particular dataset in services

Hi guys is there a way i can disable refresh in services, i know there is an option in the desktop, but serivces i couldnt find any. I have large datasets, hence refreshing all can cause time out issues. Been stuck with this for a while now. 

6 REPLIES 6
Super User IV
Super User IV

Yes, generally when you go to the Dataset | Schedule Refresh there is a slider to enable automatic refresh or not. Or are you looking to disable it altogether so that users can hit "refresh" ?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




since my datasets are large i have broken it down into different sets by year, ( the previous years shouldnt be refreshed) but the current year table should be ? 

Are they different datasets or different tables within a single dataset? In the latter case, typically you would disable the refresh on the table in the PBIX file and then when you publish to the Service refresh won't occur for that table/query.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Community Support
Community Support

Hi @ajin,

 

I think you mean that you want to disable the refresh of one of table in your dataset. Actually, it is not possbile to meet your requirement currently. However, there is an idea about that, you can vote it up.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32579875-refresh-all-except

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

My case is the latter.  I had tried doing what you had suggested here but it didnt work. I was able to disable refresh in the desktop but it doesnt support the same on services. 

Ya i was thinking on the same lines since it wasnt supporting the feature currently.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors