Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
5 years ago
Solved

Export entire m code from Power BI to power Query in Excel

Hi,

 

i have some M Code in PBI Desktop, and i'd like to import this code in Power Query in Excel.

i installed power query helper, see here but the app changed completly and i don't manage to do it.

 

is there a way to do this easily ?

 

Thanks

  • Hi GeekAlfPro 

    Sure you can just copy the queries as usual, with Ctrl-C, on the queries pane (on the left) in the query editor in Power BI and then open Power Query in Excel and paste, Ctrl-V, on the same queries pane (on the left).  That should get you all your queries moved.

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion

    Hi GeekAlfPro 

    Sure you can just copy the queries as usual, with Ctrl-C, on the queries pane (on the left) in the query editor in Power BI and then open Power Query in Excel and paste, Ctrl-V, on the same queries pane (on the left).  That should get you all your queries moved.

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

    • GeekAlfPro's avatar
      GeekAlfPro
      Helper V

      Hi AlB 

       

      that's it !

      it didn't work cause i tried to paste it in the query editor not in the pane !

       

      thanks