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
