computational notebook (like R markdown) for M langauge?

[haganistic]

Is there any computational notebook that can be used to save/ execute M langaugge commands? It will be helpful for learning and sharing queriying techniques.

[BA_Pete · Accepted solution]

Hi @haganistic ,

I guess you're thinking of something like Jupyter or similar. I don't think there's anything like this yet for M code.

Personally, I use Notepad++ for storing/saving M code. You can get an M code add-on which formats your code in M style.

I also use Dataflows in the Service for an online repository which is actually connected to data sources, and for executing code when I don't have a PBIX to hand.

Pete

[jeffshieldsdev]

That's a good idea, using dataflows as a repository.

I just wanted to add, similar to Notepad++, I use VS Code and a Power Query formatting extension. I keep my functions and snippets in text files with .pq file extension and store in a Git repo.

[Syndicate_Admin]

Yeah, the Dataflows thing is good but not very scalable unfortunately. If you share a Dataflow with someone else, they can also access it, but each person needs to 'take over' ownership of it every time they want to access the actual M code of the queries.

I've seen that VS Code before but never really looked into it.

- I presume it allows you to connect to a source and write M directly on it?

- Does the M extension include Intellisense?

Pete

[BA_Pete]

Yeah, the Dataflows thing is good but not very scalable unfortunately. If you share a Dataflow with someone else, they can also access it, but each person needs to 'take over' ownership of it every time they want to access the actual M code of the queries.

I've seen that VS Code before but never really looked into it.

- I presume it allows you to connect to a source and write M directly on it?

- Does the M extension include Intellisense?

Pete

[jeffshieldsdev]

It doesn't allow you to connect to a data source.  It doesn't have intellisense, keywords and formatting: Power Query / M Language - Visual Studio Marketplace