Load data with previous format steps

[Anonymous]

Hi guys,

i loaded my data from a folder into Power BI Desktop. My data includes multiple Excel tabels. My goal is to fusion all tabels. Before that i have to format my Data in the Power Query Editor. I have to delete the same rows over and over again. So far so good. Now over time  i want to load a new table from my file into BI. Is it possible to apply the previous format steps to the new table? At the moment i have to filter the table for the new rows and delete them maually, which takes forever with over 2 Million Rows. Any way to do it more efficient?

Thanks!

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

If the format of the loaded data model is the same as the previous one, then you can copy the steps of the query directly from Advanced editor to the newly imported table by simply replacing the path of the file. Refer to the following:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[lbendlin]

Outsource the filtering and formatting into a Power Query function.  You can then call that function for any number of Excel files, and combine the results after that.