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

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'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?