Forum Discussion
Helper IIHow to restrict data refresh for a particular dataset in services
Community ChampionYes, 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" ?
Helper IIsince 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 ?
- Greg_Deckler
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.
- ajin
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.