Value.VersionIdentity
Which version of a versioned table a value reads: its version as text, or null for the table as it is now.
Group: Values, types and errors. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Value.VersionIdentity(value as any) as any| Parameter | Type | Description |
|---|---|---|
value | any | A table read from a Delta table or an OpenBI lake, or any other value. |
Returns
any. The version as text, such as "0"; null for the latest data and for values that have no versions.
Remarks
- The steps after a version keep its identity: a filter on version 1 still says "1".
Examples
A Delta table's first version
let
Versions = Value.Versions(DeltaLake.Table(Folder.Contents("C:\Data\orders-delta")))
in
Value.VersionIdentity(Versions{[Version = "0"]}[Data])"0"A lake read as it was
let
Orders = OpenBI.Lake("lake://folder/C:\Data\shop-lake", [Version = 1]){[Schema = "main", Item = "orders"]}[Data]
in
Value.VersionIdentity(Orders)"1"The latest data
Value.VersionIdentity(DeltaLake.Table(Folder.Contents("C:\Data\orders-delta")))null