If you have a dataset in Power BI Desktop and you want to see what happens under the roof of the Vertipaq Engine, there is a great tool known as Vertipaq Analyzer. It can tell you how much space tables and columns consume, what their data types are like, what compress algorithms they use and so on. But before you can start analyzing your dataset, you need to set everything up.
In step 6 you are asked for the SSAS connection, as in the following screenshot.
But where to get the port from if you want to connect to an instance of Power BI Desktop running on your machine? The recommended way is to download DAX Studio and get it from there (also a part of the Vertipaq Analyzer instructions). However, in my work environment it was not allowed to download or install any third-party software and I had to find another solution. Power BI Desktop uses Microsoft SQL Server Analysis Services as a database engine as you can see on the screenshot of the Task Manager below.
Great, now you have the running process! When you click on “Go to details”, you will also see the process called “msmdsrv.exe” and its PID (process ID). Having the PID, you can get a local port that the process is listening on.