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
Look like there is a miss understanding , I don't want to open PQ advanced editor I wanted to use
DAX Info function like I wrote in my question
For example evaluate info.view.tables will give you tables name.
My question is is there a DAX funcrion to retrieve the source and Schema?
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