Ability for Power Query Append to Union tables without auto-refreshing them
If there are multiple tables that use different refresh frequencies, for performance reasons, you don't want them to auto-refresh whenever you union them.
Currently this is what Power Query does and you cannot disable it.
Vicky M commented
Badly need this .... basically, I want to know the reason behind why it was not implemented that way already? I agree with comment made by Andrew. I have exactly same requirement where each query bring data for a different year.. and I dont want them to refresh every day if I am appending them together in a single query
Andrew T. commented
If I have multiple years' data and this feature were in place, i'd define two data sets: one for old data and one for new data where the end date of the old data set is the start date of the new data set. Then I could turn off the refresh on the old data set, and keep it on for the new data set, append those tables and have Power BI only fetch new data. I have this setup, but it doesn't seem to work (the old data is fetched along with the new data even though the source data set has data refresh disabled)