Forum Discussion

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...

Super User

6 years ago

Anonymous try this tool, hope it helps.

Anonymous

Not applicable

6 years ago

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

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
  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
    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.
    Retrieve all measures in DirectQuery mode.pbix51 KB

Related content