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

How to omit some tables from Refreshing

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!

Helper II
Helper II

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.

Super User
Super User


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

Please let me know if it is not. 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Hi ,


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.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!