Forum Discussion

wi11iamr_'s avatar
wi11iamr_
Frequent Visitor
2 years ago
Solved

DAX Query View - User Does Not Have Permission to call Discover Method

Within Power BI Desktop I have connected to a Semantic Model in my Power BI Service. Using DAX Qury View in Power BI Desktop, I can happily evaluate any tables as follows:   EVALUATE Tasks     ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi wi11iamr_ ,

    As we can see in our tests, we are able to execute the EVALUATE INFO.MEASURES() command perfectly without fetching data from the semantic model. However, if we connect to the semantic model to process the data, there may be additional layers of security that may not be invoked if we don't have enough privileges to access it.

     

    DAX Studio uses XMLA endpoints for connectivity, which means that more privileges can be given to the user to be able to query the data model.

    Here is the document I found for you, I hope it helps to solve your problem.

    Dynamic Management Views (DMVs) in Analysis Services | Microsoft Learn

    Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

     

    Hope it helps!

    Best regards,
    Community Support Team_ Tom Shen

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.