Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Retrieve all measures in DirectQuery mode

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...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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?