RuiRomanoMS's avatar
RuiRomanoMS
Microsoft Employee
1 year ago

About table

A table that include information about the semantic model.

 

createOrReplace

	/// Table with information about the model.
	/// Key/Value representation, with properties like: last refresh; model creator;...
	table About		

		column Key
			dataType: string			
			summarizeBy: none
			sourceColumn: Key		

		column Value
			dataType: string			
			summarizeBy: none
			sourceColumn: Value			

		column Order
			dataType: int64
			formatString: 0			
			summarizeBy: none
			sourceColumn: Order			

		partition About-77c21240-7751-4575-bf40-8c068bfd01cd = m
			mode: import
			source =
					let
						Source = #table({ "Key", "Value" },{
							{ "Developed by", "Microsoft" },
							{ "Version", "1.0" },
							{ "Description", "Sales.pbip" },
							{ "Last Refresh", DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd HH:mm:ss") }
						}),
						#"Added Index" = Table.AddIndexColumn(Source, "Order", 1, 1),
						#"Changed Type" = Table.TransformColumnTypes(#"Added Index",{{"Key", type text},  {"Value", type text},{"Order", Int64.Type}}),
						#"Reordered Columns" = Table.ReorderColumns(#"Changed Type",{"Key", "Value", "Order"})
					in
						#"Reordered Columns"

		annotation PBI_ResultType = Table
No RepliesBe the first to reply