Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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!

Need Help

3 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous 

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

    Please let me know if it is not. 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.