Model Documentation INFO.VIEW Functions

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 )