How to omit some tables from Refreshing

[rnian18]

Hey guys, I have a PowerBI file with 5 data sources.  Currently, 2 data sources are broken.

In Power Query editor, I edited the other 3 working tables.  After the edit, I would click save and apply.  But my query is blocked because of the 2 broken data sources.  Is there a way to omit the 2 broken data sources when I click save and apply?  I have already tried right clicking on the data source and de-selecting the "Refresh" option for the broken tables.

Thanks in advance!

[rnian18]

Just an update on this.  The only way for the other queries to not block any new calculations is to uncheck the "Enable Load" option as well.

[VijayP]

@rnian18 

In Power  Query Editor , Just uncheck the "include in report Refresh" option ! That may help you!

Please let me know if it is not. 

[rnian18]

Hi VijayP,

I have unfortunately already tried that and it does not seem to work.  I disabled the "Include in report refresh" by right clicking the dataset and have also tried it by going into Properties, and disabling it there as well.

The data sources I am pulling from are all Web APIs.  I'm not sure if that changes anything.