none
Can I copy Power Query queries to other Excel workbook ? RRS feed

  • Question

  • Can I copy Power Query queries to other Excel workbook ?
    I want to copy some Power Query queies to other Excel workbook.

    a workbook have some queries about population.
    a workbook have some queries about labor market.
    I want to build a workbook with population queries and labor market queries for sharing OneDrive.

    Regards,
    Yoshihiro Kawabata

    Monday, May 5, 2014 6:07 AM

Answers

  • The easiest way to do this is probably to open the editor and go to View | Advanced Editor and copy out the M code. Then create a new "From Blank" query in the target workbook, open the advanced editor and paste the code.
    Monday, May 5, 2014 4:22 PM

All replies

  • The easiest way to do this is probably to open the editor and go to View | Advanced Editor and copy out the M code. Then create a new "From Blank" query in the target workbook, open the advanced editor and paste the code.
    Monday, May 5, 2014 4:22 PM
  • Thank you, Curt.

    Yes, Now I copy by M code.

    I want  more easy way.
    When sharing Query at Power BI, Excel automatically share all related queries by one click.

    Regards,
    Yoshihiro Kawabata 

    Monday, May 5, 2014 10:45 PM