Possible to "pause" or disable update from a data source?

[Daryl_K]

Is it possible to disable or pause udates from a single data source without deleting it?

Here's why I ask: I've been given a very large and complex pbix file that I am responsible for modifying. It has dozens of data sources, and I need to compile a list of which ones I have to be granted access to, but as you know refresh stops at the first one that errors and will not proceed. What I'd like to do is pause/disable that one so it continues on to other data sources, then if I get another error note which source, then pause/disable that one and start again, etc. etc.

This way I can turn in a comprehensive list to IT all at once, rather than piecemeal.

[v-yiruan-msft]

Hi @Daryl_K,

You can disable “Enable load” and “Include in report refresh” option in Power Query Editor. You can refer the following documentations for the details if you will work on Power BI Desktop. "Include in report refresh" option only works for Power BI Desktop, it doesn't impact the refresh process in Power BI Service.

https://community.powerbi.com/t5/Desktop/Difference-with-Enable-Data-Load-amp-Include-in-Report-Refr...

https://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-report-refresh-quot-not-working/t...

Best Regards

Rena

[amitchandak]

You should be able to do at table level ?

[PaulDBrown]

@Daryl_K 

You can disable refresh and/or load in Power Query by selecting the table and right-clicking on it to access the options menu for that table.