Export a readable documentation of all queries and steps

[Spigaw]

Hello dear queriers,

Since I began working with Power Query and PBI, I have been looking for an easy way to export what is happening in all the queries and steps they contain, in a format that would be easily readable by anyone needing to use or edit it. I would then be able to create a full documentation.

I tried copying the code from the advanced editor into a Word document, but formatting disappears.

Is there any way to export a documentation from Power Query?

Thanks in advance for any help.

[ChemEnger]

Replying to an old thread.

There is (now?) a workaround for this - if you copy the M code from the desktop file & paste it into a query on the Power BI Service, the formatting will be re-created, and maintained if you then copy & paste it back into e.g. Word (maybe something to do with HTML rendering or something?)

[Syndicate_Admin]

To copy out the text of all your queries:

1. Open Power Query Editor
2. Select all the queries in the Queries area
3. Right-click->Copy
4. Paste into an editor (MS Word, Notepad, MS Code etc.)

[AlexisOlson]

Just in case you weren't aware, you can select all of your queries at the same time and copy and paste them into a text editor (or another Power Query editor) all at once.

[joannm]

OMG, I can't believe I never tried this. You just saved me so many clicks. Thanks loads!

[CNENFRNL · Accepted solution]

AFAIK, there is no official format of PQ snippet, after all, the M is so far not as widely used as sql or html. But some guru has develop this formatter worth trying:

Power Query Formatter | Beautify your Power Query code

[Spigaw]

Excellent tool, thanks for the link. Here is how I will work with this:

• Format my code with Power Query Formatter
• Convert it to a readable format with this from Pinetool
• Paste it into Word.

Thank you so much!