Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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)