Forum Discussion
Power Query Applied steps
In power query editor there is list of applied steps can we apply these steps to a new excel file automatically?
Hi Anonymous ,
According to your description, here's my solution.
1.In Power BI Power Query, open Advanced Editor and copy the whole code.
2.In Excel, launch Power Query Editor.
3.Create a blank query through Home>New Source>Other Sources>Blank Query.
4.Then in Excel Advanced Editor, paste the M code copied in step1 in it.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I Think I missed that I am talking about Power Bi not excel file. My question is In power BI power query editor there is list of applied steps can we apply these steps to a new excel file automatically?