DaxStudio List of Measures

[Anonymous]

I am trying to generate a list of measures that exist on a PBI desktop file with a live connection to a SQL database. Using DaxStudio "select * from $SYSTEM.MDSCHEMA_MEASURES" retrieves the Measures that exist in the backend SQL db but not the measures that exist on the Desktop file!

Any ideas? 

[edhans]

Is your data in SSAS on the SQL server, because DAX measures don't exist in SQL databases themselves, just SSAS. 

If SSAS, have you confirmed you connected DAX Studio to your PBIX file when it was open? It defaults to connecting to an SSAS server (third radio button when DAX Studio launches)

[Anonymous]

Hi Edhans

I tried to connect to the Opened local PBIX file that has the live connection to SQL and get the following message.

Then when I Connect to the Tabular Server I do see all the tables in the PBIX file. Run select * from $SYSTEM.MDSCHEMA_MEASURES and it will not list any of the measures that I created in the Desktop App. Only shows measures that were developed in SQL(I think!) not by me anyway!

[edhans]

Right, because the SSAS server doesn't know what you've done in the PBIX file. To connect to the PBIX file do the following:

1. Close DAX Studio.
2. Start Power BI Desktop and load the PBIX file
3. Start DAX Studio
4. Connect to the Power BI desktop file.

If you do it in any other order, it likely will not connect.

[Anonymous]

---

---

@edhans wrote:

Right, because the SSAS server doesn't know what you've done in the PBIX file. To connect to the PBIX file do the following:

1. Close DAX Studio.
2. Start Power BI Desktop and load the PBIX file
3. Start DAX Studio
4. Connect to the Power BI desktop file.

If you do it in any other order, it likely will not connect.

---

Thanks. I tried what you suggested and got the following message.

---

[edhans · Accepted solution]

Well, if you are connecting to SSAS via Live Connection vs Import, then that is the answer. It cannot show you your own measures in the PBIX file at this time. I don't know if that is a feature that is being worked on or not.