topic Re: M code formatter in Developer

M code formatter

rafaelsmoreno — Mon, 11 Mar 2019 18:50:17 GMT

Hi folks!

Just checking if any of you know a code formatter for M. I googled it but couln't find anything, so if you guys know one, please share in this post.

Thanks in advance,

Re: M code formatter

Stachu — Mon, 18 Mar 2019 13:13:57 GMT

I don't know of any M formatter as such, but in the PowerBI preview features there is M intellisense

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2018-feature-summary/

which makes the code much more readable

Re: M code formatter

mwimberger — Tue, 22 Oct 2019 01:32:52 GMT

Hi @rafaelsmoreno

Reza Rad has a Beautify M Script function in his tool https://radacad.com/beautify-m-script-and-extract-row-level-security-with-power-bi-helper-version-4-0

Whilst it doesn't do a similar job to what the Dax Formatter (https://daxformatter.com ) does, and the newest updates to Power Query offer the Intellisense colour coding, this Power BI Helper tool does remove the extra tab paddings before lines, and offers the ability to get all your M code copied out in one place. Useful for archiving Queries.

There is also a way to get Notepad++ to have M language formatting https://community.powerbi.com/t5/Community-Blog/Get-your-own-Power-Query-Editor-using-Notepad/ba-p/146347

Bear in mind that if you like dark mode, you should set your custom setup to be compatible with this else it looks pretty messed up.

Cheers

Manfred

Re: M code formatter

Geradav — Wed, 15 Apr 2020 15:14:08 GMT

It is now available!

https://powerqueryformatter.com/

Regards

Re: M code formatter

mwimberger — Sun, 26 Apr 2020 22:02:59 GMT

Hi @Geradav this is great! I gave it a test out yesterday evening and one M query worked wonderfully, and the other didn't, but both run perfectly in Power Query with no syntax errors within PQ. Weird.🤔

I'll post the issues on Github once today's workload is done.

Cheers

Manfred

Re: M code formatter

ppvinsights — Wed, 13 May 2020 06:05:35 GMT

Hi Manfred,

yes, the PQFormatter is more or less in beta - still some functionality missing. Just send a bug report to github - we fix it, if we can 🙂

Holger

Re: M code formatter

mithra — Fri, 15 Nov 2024 01:33:43 GMT

Please check the following site

https://www.powerqueryformatter.com/