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 form...
Need Help
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?

    • edhans's avatar
      edhans
      Community Champion
      4 years ago

      Not that I am aware of.