Forum Discussion
calculated columns table
You can do, but you need to find out the port number Power BI Desktop is sitting on it.
To do this run the following from the command prompt
TASKLIST /FI “imagename eq msmdsrv.exe” /FI “sessionname eq console”
this should give you a table of data.
What we want is the PID from the list for msmdrv.exe
this will be a number between 1 and 999999
next use that number in the following command at the command prompt
netstat /ano | findstr “nnnnn”
replace the nnnnn with the number from step 1. This gives you the current port number your Power BI Desktop is listening on. It will change when you close and reopen the app.
Now, click the Get Data button and choose "Analysis Services"
In the ServerName type localhost:nnnnn
The nnnnn in this case should be the number from the 2nd column of the output of the netstat command.
This will allow you to connect to your data model.
You'll need to navigate through to the tables in order to get the GUID For the database name.
Once you have the database name you can re-connect to "Analysis Services" and this time enter both the Servername AND the Database name. Here is where you can enter one of the DMV queries to give you details of your measures and columns.
The easier way is just to take your PBIX file to a machine that has DAX Studio (a home PC perhaps?)
Thanks Phil_Seamark. Unfortunately I am not allowed to install anything on my computer. So I assume there is no inbuilt way to do it in Power BI?
You can do, but you need to find out the port number Power BI Desktop is sitting on it.
To do this run the following from the command prompt
TASKLIST /FI “imagename eq msmdsrv.exe” /FI “sessionname eq console”
this should give you a table of data.
What we want is the PID from the list for msmdrv.exe
this will be a number between 1 and 999999
next use that number in the following command at the command prompt
netstat /ano | findstr “nnnnn”
replace the nnnnn with the number from step 1. This gives you the current port number your Power BI Desktop is listening on. It will change when you close and reopen the app.
Now, click the Get Data button and choose "Analysis Services"
In the ServerName type localhost:nnnnn
The nnnnn in this case should be the number from the 2nd column of the output of the netstat command.
This will allow you to connect to your data model.
You'll need to navigate through to the tables in order to get the GUID For the database name.
Once you have the database name you can re-connect to "Analysis Services" and this time enter both the Servername AND the Database name. Here is where you can enter one of the DMV queries to give you details of your measures and columns.
The easier way is just to take your PBIX file to a machine that has DAX Studio (a home PC perhaps?)