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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much for your recomendation but can you please tell me specifically about my problem? how I can apply same steps to other same formated excel file?

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

Sure. The quick answer.

 

  • Excel Files A and B each contain one worksheet named Sheet1
  • Sheet1 contains a single table named Table1
  • Each workbook needs some sort of pre-process data activity on the data from Table1 that Power Query is able to fulfill through the use of a query that is made up of a series of 
    recorded steps.
  • A query is plain text and can be saved, viewed, and edited outside of Power Query.
  • Copying a query from File A to File B would work in this specific case.

 

General Steps:

 

From File A select the desired query, and copy the query using the following steps :

 

Data Tab > Queries & Connections > Queries & Connections > Queries > right click on Query of Interest and choose Copy from the flyout menu.

 

Then, change to File B, follow the same steps, and in this case, paste the copied query from File A.  It is prudent to edit the query pasted to File B to verify the Source and any transformations are as desired.

 

That is the key reason I answered an open question with a broad answer that would allow for a clearer understanding of Power Query and how to get started with it.