Forum Discussion
computational notebook (like R markdown) for M langauge?
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.
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
5 Replies
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
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.
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
