0

I have a Power BI report which I need to update one in a while. All its tables were loaded from some internet URL, but only one of them needs to be updated, all the others have static data.

  • How do I make Power BI stop trying to reload the static tables?
  • Or how do I copy the data from these tables into new "non-internet-loaded" tables?
Daniel Möller
  • 84,878
  • 18
  • 192
  • 214

1 Answers1

1

In the Query Editor, right-click on the queries and toggle off Include in report refresh where appropriate.

enter image description here

(The Enable load toggle is useful for queries that you only use for staging and don't actually want to load into your model.)

Alexis Olson
  • 38,724
  • 7
  • 42
  • 64
  • In Power BI desktop this is right answer. However when report is uploaded to Power BI service, then it doesn't work as per comments in this answer - https://stackoverflow.com/a/42073034/1779091 – variable Jan 17 '21 at 08:49