Tools

Powerful DAX & Power Query editor

If you feel not very comfortable with DAX & Power Query editor, have a look at Visual studio code. It provides very efficient and powerful text functions including auto completion, Intellisense, advanced search & replace, …

You will edit your code in different tabs and keywords are coloured according to the language you use.

Much more extensions are available to edit other codes. For instance, you can edit C++, HTML, batch code. The list is long.

How to

  1. First, download Visual studio code : https://code.visualstudio.com/

2. And add DAX and Power Query extensions

3. Then enjoy

Additionaly, you will be able to save your favorite code and to create workspaces.

Though you will need to copy and paste your code from Power Query to Visual studio code and vice versa, you will save a lot of time. Above all, you will not need to close and open the advanced editor to check other pieces of code.

In conclusion, give it a try ! It’s worthy.

Tabular editor

Tabular editor website : https://tabulareditor.github.io/


Developper tools

BI Developer Extensions (previously BIDS Helper)

A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT).
https://bideveloperextensions.github.io/

SQL Server Analysis Services Tabular Protocol

Documentation of the Microsoft SSAS APIS
https://sqlprotocoldoc.blob.core.windows.net/productionsqlarchives/MS-SSAS-T/%5BMS-SSAS-T%5D.pdf