Using Visual Studio Code to write M Code

[RichFlorida]

I'm a novise in this subject.

I'm trying to use VS Code to write and debug M-code for my PowerBI Report.

How can I make VSC IDE communicate with the Power BI dataset to be able to see the Power BI tables and columns in VSC?

Thanks

[pcoley]

The PowerQuery M Language provides features like syntax highlighting, code formatting, and IntelliSense. The official Microsoft tools also include a Power Query SDK for custom connector development.
But it does not allow you to run or debug the M code directly within VS Code itself. The code must still be executed within a Power Query host environment, such as Power BI Desktop or Excel. 

I think you can have a better resolution using MCP: 
https://marketplace.visualstudio.com/items?itemName=analysis-services.powerbi-modeling-mcp

I hope this helps. if so please accept as a solution. Kudos are welcome.

[pcoley]

i realize that you are trying to see and play with the data in the same ide.
Then please try with:
https://www.sqlbi.com/tools/dax-studio/

[v-jingzhang]

Hi @RichFlorida 

You may have a look at this tool Power Query / M Language - Visual Studio Marketplace

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[TheRaggy]

Thanks very helpful