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

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

parry2k's avatar
parry2k
Super User
6 years ago

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