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 the files get more and more I want to avoid so many queries and files.
Is there a way how to combine the queries in one big query and to remove the connection with a files or with previous queries.
Something like this:
1. Combine Query 1 and Query 2 ind Query 3
2. Remove the connection of Query 3 to Query 1 and Query 2.
Thank you
2 Replies
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.
