Forum Discussion

SSG0401's avatar
SSG0401
New Member
3 years ago

Single Power Query for Multiple Files with minor change

I have over 150 excel files. All have the same power query code except the source.   When I have to make any changes in the code, I have to edit 150 files. Is there a way to have the same code in a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SSG0401 ,

 

Did you use the power query in power bi desktop? If so, you can try templates in Power BI Desktop.

Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn

 

Or you can use the from folder, and combine all the files.

Combine files overview - Power Query | Microsoft Learn

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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