disable refresh in Desktop only

markmsc Couple methods of doing something like this. One would be to create the model in the Desktop and turn on Incremental refresh. Your data can remain small in Desktop but the Service will refresh the data incrementally. Normally this kind of method is coupled with using something like the ALM Toolkit to just publish modifications made instead of the entire report itself.

Another method is using Query parameters. So in the Desktop you create a parameter that allows you to grab, let's say, the last 2 years of data only. You then use deployment pipelines to automatically update that parameter where you pull all of the data.

Probably more ways to do it but those are the first 2 that I thought of.