Creating Keywords highlighting via the GUI of Notepad++.

What you need to do to get your Power Query EditorĬreating your own M editor in Notepad++ is not complicated and can be seperated in the following steps: It is completely FREE and will take your M Code to the next level

If you are dealing with these scenarios as well and you find my solution interesting, please read further and learn how to get it. Commenting becomes more important, the longer and complex your M code gets. Syntax highlighting helps to keep (or get) an overview over your M code. Scenario 2: Taking a look at M code with highlighted keywords and comments Especially the help texts help you to get more familiar with the M language. Using the editor makes it much easier to find the function that fits your needs. Scenario 1: Finding the right function for my problem This is why I was investigating a bit and found a solution, which I hope will be helping others as well.

The number of Power Query functions are getting more every month and I am always looking for the right function for my specific problem. What I was still missing was parameter hints and help texts. Matt’s tool already had intellisense and syntax highlighting. At that time I did not even know that it was possible to create a custom language in Notepad++. He showed how to create an editor for Power Query with Notepad++. Matt is a Senior Program Manager at Microsoft and member of the Power BI Developer Team. In 2015 I read the following article, written by Matt Masson. The fact, that M is case sensitive doesn’t make it easier at all. The Power Query Advanced Editor comes without intellisense (auto completion), no parameter hints, no syntax highlighting, no help texts, which explain what the functions do, no nothing. Many of you know that Power Query is an amazing tool for data import and data transformation.

Notepad++ json color