Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
To copy out the text of all your queries:
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.
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
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Excellent tool, thanks for the link. Here is how I will work with this:
Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.