Maintain the old data without refresh

[locle90]

Dear All,

I have the sales data for 2019,2020,2021 and 2022 ( .txt file with several years). I created the old folder and combine all files in a power query. The current year is in the other table then I will append 2 tables to the sales data.

The problem is the append table always load the old year when i refresh and take a long time.I already tried to uncheck load data on the old table but the append table have.

So do we have any solution to keep old data on the report but no need to load or refesh any more ?

Th

[AlexisOlson]

A workaround (not really a solution) for this scenario I've used occasionally is to combine the historical files in Excel using Power Query and then point Power BI at that Excel file where the files have already been combined and saved rather than loading from the folder directly. This way the combining of all the historical data only has to happen once.

[v-kkf-msft]

Hi @locle90 ,

The auto-refresh will always happen when using Power Query append function, please vote this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=ef88fe05-5283-463f-9f9e-bdd142c35c43 

Well, one option that you might have would be to ditch the Append query and load both tables into the model. Hide them and create a DAX UNION table. Then you could then disable refresh on the one query. 

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.