DMV against XMLA endpoint - user does not have permission to call discovery method

[AUaero]

Hi,
I'm playing around with the DMV views in DAX Studio to query data about my models in a Premium workspace using the XMLA endpoint.  I can run most of the queries successfully, but when I try to run the following query I get an error:

select * from $SYSTEM.DISCOVER_DB_CONNECTIONS

DAX Studio returns an error saying "user does not have permission to call the Discover method" in spite of the fact that I am an admin in the workspace I am connecting to.  Is there a limitation here that I don't understand?

Thanks!

[waltheed]

In this article (about DMVs) it says that:

"For Power BI Premium semantic models, DMVs for querying through the XMLA endpoint are limited to those that require database admin permissions. Some DMVs are not supported because they require Analysis Services server admin permissions."
Apparently the $SYSTEM.DISCOVER_... DMVs are not supported. 
The other types ($SYSTEM.TMSCHEMA_..., $SYSTEM.DMSCHEMA_..., $SYSTEM.MDSCHEMA_...) do work. 

[Martin_inndx]

Hi. I'm getting the same error if I run this query from SQL Management Studio: 

 SELECT
[DIMENSION_NAME] as [SemPyDimensionName],
[TABLE_ID]       as [SemPyTableExpr],
[USED_SIZE]      as [SemPyUsedSize],
[SEGMENT_NUMBER] as [SemPySegmentNumber]
FROM
$SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS

I also get the error when I do this in a Fabric notebook:

import sempy.fabric as fabric
all_columns = fabric.list_columns(workspace="prod-xxx-ws", dataset="prodxxxlakehouse", 
extended=True)

[trialuser290923]

I'm getting the same error. Is the issue resolved?

[Daryl-Lynch-Bzy]

Hi @AUaero - it did not work for me either.  Could you please ask this question in the DaxStudio GitHub instead please.  Issues · DaxStudio/DaxStudio (github.com)