Retrieve all measures in DirectQuery mode

[Anonymous]

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]

@Anonymous try this tool, hope it helps.

[Anonymous]

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

[parry2k]

@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]

If I install DAX Studio only for me, it does not require admin rights.

But is there any way to get the measure list without installing any third party tool?

[v-xuding-msft]

Hi @Anonymous , 

Please view the gif below. Maybe it can help you.

• 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/

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]

Thank you for your answer.

It raises me an eror: "An error happened while reading data from the provider: 'The MSOLAP.8 provider is not registered on the local machine."

I guess I should download MSOLAP (amd64) from here and ask admin to install it.

Edit: installation solved the problem, but I have no value in the request...

And there is at least one measure:

Do you know why?