Source control for M and DAX code

Although the version history of M and DAX code within Power BI Desktop files is technically available via OneDrive for Business, some BI organizations may also choose to utilize more robust version control tools on essential queries and measures. For example, the M query used to retrieve the Customer dimension table could be saved as a .pq file and synchronized with a team project code repository in VSTS. This approach would improve the visibility of the code to project team members and, for M queries, provide the code editing benefits of colorization and IntelliSense.

In the following screenshot, a Power Query project containing multiple folders of PQ files (M queries) has been added to a solution in Visual ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.