How to keep the data in a query and remove the source file

[GIvanov]

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

[ppm1]

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

[GIvanov]

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.