Power BI, Data Dictionary anlegen
Um ein Data Dictionary in Power BI anzulegen,
in Datenmodellierungssicht eine neue Tabelle anlegen und folgenden DAX Code einfügen:
--- SCHNIPP ---
Data Dictionary =
VAR _columns = SELECTCOLUMNS(
FILTER(
INFO.VIEW.COLUMNS()
, [Table] <> "Data Dictionary" && NOT([IsHidden])
)
, "Type", "Column"
, "Name", [Name]
, "Description", [Description]
, "Location", [Table]
, "Expression", [Expression]
)
VAR _measures = SELECTCOLUMNS(
FILTER(
INFO.VIEW.MEASURES()
, [Table] <> "Data Dictionary" && NOT([IsHidden])
)
, "Type", "Measure"
, "Name", [Name]
, "Description", [Description]
, "Location", [Table]
, "Expression", [Expression]
)
RETURN
UNION(_columns,_measures)
--- SCHNAPP ---
Kommentare
Kommentar veröffentlichen