DeltaLake.Metadata

Accessing Data

Returns the transaction log entries for a Delta Lake table.

Syntax

DeltaLake.Metadata(table as table) as table

Parameters

Name	Type	Required	Description
`table`	`table`	Yes	A Delta Lake table (as returned by DeltaLake.Table) whose transaction log entries you want to retrieve.

Return Value

table — A table containing the transaction log entries for the specified Delta Lake table.

Remarks

DeltaLake.Metadata accepts a Delta Lake table and returns its transaction log entries. The Delta Lake transaction log (also known as the Delta log) records every change made to the table — including commits, schema changes, partition modifications, and file-level additions and removals. This function is useful for auditing, lineage tracking, and understanding the history of a Delta Lake table.

The table parameter should be a value previously returned by DeltaLake.Table. Passing a non-Delta table will result in an error.

Platform availability: This function is available in environments that support the Delta Lake connector, including Power BI Desktop, Power BI Service (via supported lakehouse/storage connections), Dataflows, and Fabric Notebooks. It is not available in Excel.

Examples

Example 1: Retrieve the transaction log for a Delta Lake table

```powerquery

let
    DeltaTable = DeltaLake.Table("https://myaccount.dfs.core.windows.net/mycontainer/delta-table"),
    Metadata = DeltaLake.Metadata(DeltaTable)
in
    Metadata

Compatibility

✓ Power BI Desktop✓ Power BI Service✗ Excel Desktop✗ Excel Online✓ Dataflows✓ Fabric Notebooks