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