Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.