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

[wi11iamr_]

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.

[Anonymous · Accepted solution]

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

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.