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

[UsePowerBI]

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!

[v-eqin-msft]

Hi @UsePowerBI ,

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.

[edhans]

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.

[UsePowerBI]

@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]

Not that I am aware of.