Forum Discussion
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
When I however try to access any DMVs/Functions such as
select * from $SYSTEM.TMSCHEMA_MEASURES
or
EVALUATE INFO.MEASURES()
then I get the error
The %username% user does not have permission to call the Discover method.
Technical Details:
RootActivityId: a3f294a3-c69b-475b-b0c5-cc8f833e2048
The above queries work just fine in DAX Studio where I admittedly have to specify the Initial Catalog
But within PowerBI Desktop, although I can happily create reports using this semantic model, I just cannot inspect it within DAX Query View.
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
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.