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
Hi, To extract Source and Schema details in Power Query:
Open Advanced Editor:
a.Inspect the M code, e.g.,
let
Source = Sql.Database("localhost", "AdventureWorksDW2022"),
dbo_DimProduct = Source{[Schema="dbo", Item="DimProduct"]}[Data]
in
dbo_DimProduct
b. Source: Sql.Database, Schema: "dbo".
2. For Excel:
let
Source = Excel.Workbook(File.Contents("C:\Data\Example.xlsx"), null, true),
Table1 = Source{[Item="Table1", Kind="Table"]}[Data]
in
Table1
a.Source: Excel.Workbook, Item: "Table1".
3.List All Sources and Schemas: Use the following query:
let
AllTables = Excel.CurrentWorkbook(),
Metadata = Table.AddColumn(AllTables, "SourceDetails", each try Value.Metadata([Content]) otherwise null)
in
Metadata
Note: DAX cannot retrieve this metadata directly. Use Power Query or external tools like DAX Studio instead
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