Power BI Sidetools

Power BI Sidetools, a free external tool

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop.

Many thanks to Reid Havens for helping me to showcase Power BI Sidetools

DAX debugger

DAX debugger

DAX debugger is meant to help Power BI report developers displaying sample data from a DAX formula. Measures, calculated columns and calculated tables can be debugged very easily without impact on calculation performance. An advanced mode allows user to fine tune how data is displayed :
https://thebipower.fr/index.php/2021/04/05/dax-debugger/

Easily export data to Excel

Export to Excel

Export your Power BI desktop data into Excel with only one click. Then you can setup pivot tables, add theme & graphics, macros and do whatever you want. You can even generate a paginated report. Next time you will open this file from Power BI Sidetools, it will be refreshed and you will keep all the setup you did previously. Super quick and super efficient in few steps :
https://thebipower.fr/index.php/2020/10/30/easily-export-to-excel-with-power-bi-sidetools/


Transfer DAX and M formulas to files

Power BI Toolbox

With just one click, you can transfer M and DAX formulas in a folder named like your report. The very first use case will be probably to save your different versions in backups. Right click on your report name and select “Send to/Compressed folder”.

View your DAX and M formulas in Visual Studio Code

Power BI Toolbox

With just one click, you open Visual Studio code to view your DAX and M formulas.

Visual Studio Code is a lightweight but very powerful free source code editor created by Microsoft. Its functionalities are really amazing :

  • Powerful editing capabilities including advanced search and replace across multiple files, compare files, …
  • Flexibility splitting the editor to display multiple files simultaneously
  • Themes
  • Snippets (reuseable pieces of code)
  • Plugins
    • syntax highlighting and/or intellisense (DAX, M , R, Python, SQL, Json … )
    • GIT functionalities
    • Collaboration
    • Azure management
    • Color picker
    • And much more …

Discover VSCode with videos :

Visual Studio Code docs : Introductory Videos

Microsoft ignite : Empowering Ops with VS Code


Setup

Download Power BI Sidetools from it’s GitHub repository

Some functionalities of Power BI Sidetools depend on XMLA end point access. As it is a preview feature in Power BI desktop, at the moment, I recommend you use it on copies of your reports.

Have a look at this article from Microsoft to know more about external tools limitations : https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-external-tools

Contribution

Do you have comments, propositions for new functionalities, bug report ?
Please create an issue for problems in GitHub : https://github.com/didierterrien/Power-BI-Sidetools/issues
or a discussion for ideas : https://github.com/didierterrien/Power-BI-Sidetools/discussions

It’s just a beginning …

You probably have a question right now : will it be possible to modify DAX and M formulas within Visual Studio Code ? The reply is … yes … most probably.
Please stay tuned to discover more functionalities coming soon. You may subscribe to to be aware of new content clicking here.