Forum Discussion
How to keep the data in a query and remove the source file
I get monthly Excel files (50.000 - 100.000 rows) always in the same format. Until now I always make a single query for each file and then I combine them in a big query where I get all the data. As ...
This can be done much more easily with the Combine & Transform feature. Have you tried it?
Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn
Pat
This method facilitates combining the files indeed, but the problem with the source file remains.
I would like to have the combined data as an independent data set, so that if I change data in my source file or if I remove my source file, I do not get those changes in the combined data.