Power Bi - Load table from internet only once

Question

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?

Answer 1

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

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