The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
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.
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)
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)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |