Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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?
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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 _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

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 _ kalyj

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