Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Is it possible to export a Connection including the Power Query code?

Hello

 

The Export Connection feature seems to output a connection but it misses out all the Power Query processing steps.

 

Is there a way to export the complete Query in a notepad-editable format?

 

Thanks!

Need Help

4 Replies

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    You can right-click on the query and press COPY, then PASTE into Notepad. THat will paste that query and all precedent queries it depends on as text.

    But no way to automate that that I am aware of. other than some C scripts in Tabular Editor.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      edhans  that works thanks!

       

      However, I was looking at a combination of the odc xlm plus the Power Query code in one file! Is that possible?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    You may refer to this blog to check the DataMashup File

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