IntelliSense with M Query in Power BI

Share on facebook
Share on twitter
Share on linkedin

In the September update for Power BI Desktop, Microsoft has finally added intelliSense to the M Query advanced editor. This is a great addition for learning the M Query syntax and seeing what functions are available without having to lookup the reference documentation. This feature is not available in the formula bar. Only the advanced editor will have the intellisense.

IntellisenseAdvancedEditor.png

In order to get this new functionality, you will first need to download the latest version of Power BI here. Once you have the latest version installed, go to File > Options and Settings > Options. Select Preview features in the left navigation. Check the checkbox next to M Intellisense and select OK. Power BI Desktop will need to be restarted in order to see the newly enabled feature.

PBIPreviewFeatures.png

If you have any questions or comments, please reach out to me on Twitter.

More to explore

Leave a Reply

Your email address will not be published. Required fields are marked *