Guidelines/Tutorial requested for controlling Query refresh

[mikecro]

In the Query Editor I am making extensive use of query tables referencing a single source table which in turn loads data from a big csv file.

In development I don't really want to refresh from the csv unless I have had to fix a data error.

And what I find is that each table goes back to teh source, even though the base table has been refreshed.

By default all of the tables have "Enable Load" checked - but I think that just controls visibility to the Report half of Power BI

And by default all have "Include in Report Refresh"

What is the quick way of making so that I can move to a step without refreshing from source csv. And how can I only reload from source once - not once per table.

is there a good article on this please?

[v-chuncz-msft]

@mikecro,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Difference-between-Reference-and-Duplicate/td-p/102630

[mikecro]

Extra info - and this may help somebody; I don;t get the same issues when I save the source csv file and a .xlsx

It seems the refresh cycle is different with csv.

So I will develop using the test file and edit the query to generate the production version.

Though best would be for my data providers to provide an real Excel file