If you want happy live-connecting Power BI report developers regarding providing them with global semantic model measure expressions, etc. You can include this auto-updated table to be part of your semantic model for technical info on how you calculated the measures, calculated columns, descriptions on tables or relationships.
Check it out
createOrReplace
table 'Model Documentation'
column Type
displayFolder: Attributes
summarizeBy: none
isNameInferred
sourceColumn: [Type]
annotation SummarizationSetBy = Automatic
column Name
displayFolder: Attributes
summarizeBy: none
isNameInferred
sourceColumn: [Name]
annotation SummarizationSetBy = Automatic
column Description
displayFolder: Attributes
summarizeBy: none
isNameInferred
sourceColumn: [Description]
annotation SummarizationSetBy = Automatic
column Location
displayFolder: Attributes
summarizeBy: none
isNameInferred
sourceColumn: [Location]
annotation SummarizationSetBy = Automatic
column Expression
displayFolder: Attributes
summarizeBy: none
isNameInferred
sourceColumn: [Expression]
annotation SummarizationSetBy = Automatic
partition 'Model Documentation' = calculated
mode: import
source =
VAR _columns =
SELECTCOLUMNS(
FILTER(
INFO.VIEW.COLUMNS( ),
[Table] <> "Model Documentation" && NOT ( [IsHidden] )
),
"Type", "Column",
"Name", [Name],
"Description", [Description],
"Location", [Table],
"Expression", [Expression]
)
VAR _measures =
SELECTCOLUMNS(
FILTER(
INFO.VIEW.MEASURES( ),
[Table] <> "Model Documentation" && NOT ( [IsHidden] )
),
"Type", "Measure",
"Name", [Name],
"Description", [Description],
"Location", [Table],
"Expression", [Expression]
)
VAR _tables =
SELECTCOLUMNS(
FILTER(
INFO.VIEW.TABLES( ),
[Name] <> "Model Documentation" && [Name] <> "Calculations"
&& NOT ( [IsHidden] )
),
"Type", "Table",
"Name", [Name],
"Description", [Description],
"Location", BLANK( ),
"Expression", [Expression]
)
VAR _relationships =
SELECTCOLUMNS(
INFO.VIEW.RELATIONSHIPS( ),
"Type", "Relationship",
"Name", [Relationship],
"Description", BLANK( ),
"Location", BLANK( ),
"Expression", [Relationship]
)
RETURN
UNION( _columns, _measures, _tables, _relationships )
