Forum Discussion
Data dictionary
At the moment, there's no direct way of generating this in DAX, but there are some workarounds...
1. You can directly query your model using the DAX Query View. You can then check for it in the "QueryDefinition" field.2. You can use a 3rd party application to retrieve that information such as DAX Studio and query the DMV and selecting the schema partitions:
3. Third method, if your model is saved on Power BI service, you can query the same model to return you all your query definitions:
AnalysisServices.Database("powerbi://api.powerbi.com/YOUR_WORKSPACE_ID" "YOUR_DATASET_NAME", [Query= "select * from $SYSTEM.TMSCHEMA_PARTITIONS"])Hope that helps!
Thanks,
It works
At the moment, there's no direct way of generating this in DAX, but there are some workarounds...
1. You can directly query your model using the DAX Query View. You can then check for it in the "QueryDefinition" field.
2. You can use a 3rd party application to retrieve that information such as DAX Studio and query the DMV and selecting the schema partitions:
3. Third method, if your model is saved on Power BI service, you can query the same model to return you all your query definitions:
AnalysisServices.Database("powerbi://api.powerbi.com/YOUR_WORKSPACE_ID" "YOUR_DATASET_NAME", [Query= "select * from $SYSTEM.TMSCHEMA_PARTITIONS"])
Hope that helps!
Thanks,
It works