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!

[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)