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 --- Quelle