Retrieve all measures in DirectQuery mode

Question

I want to get a list of all the measure that have been created in a .pbix file.

I read that I can with DAX Studio, but I have got a message while connecting to my Power BI file :

"No databases were found in the when connecting to localhost: [...] please connect directly to the source instead."

And if I try to use Excel to connect it to Power Query as a SSAS server instance, I find no data in the extract.

I guess it is because the .pbix file is connected in DirectQuery mode.

Do you know an other way to view all measures created in the .pbix file?

Thank you

parry2k · Answer

Anonymous try this tool, hope it helps.

v-xuding-msft · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;
Please view the gif below. Maybe it can help you.
&nbsp;

Change 61200 to your own localhost code

= OleDb.Query("Provider=MSOLAP.8;Data Source=localhost:61200;Update Isolation Level=2", "SELECT * FROM $SYSTEM.MDSCHEMA_MEASURES")

Reference:
https://ssbi-blog.de/blog/technical-topics-english/how-to-identify-measures-not-used-in-your-pbix-file/
&nbsp;
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi, thanks for your help, but I do not have admin rights to install this tool...

parry2k · Answer

Anonymous well that is internal policy problem, not sure what else to say? How you end up installing DAX Studio? Just curious, do the same for this tool.

anonymous · Answer

If I install DAX Studio only for me, it does not require admin rights.&nbsp;But is there any way to get the measure list without installing any third party tool?

Forum Discussion

Retrieve all measures in DirectQuery mode

6 Replies

Related content

Directquery measure help

DirectQuery - Measures problem?

Retrieving data via HTML

DirectQuery Semantic Model

Cannot retrieve Contacts from API