Skip to content

Instantly share code, notes, and snippets.

@pawarbi
Created June 16, 2023 13:25
Show Gist options
  • Save pawarbi/398b11540a62b1c8fae43423e022383c to your computer and use it in GitHub Desktop.
Save pawarbi/398b11540a62b1c8fae43423e022383c to your computer and use it in GitHub Desktop.
Importing Delta Tables From Fabric OneLake Lakehouse in Power BI Without SQL Endpoint
let
Source = Lakehouse.Contents([]),
//replace workspace_id
ws = Source{[workspaceId="workspace_id"]}[Data],
//replace lakehouse_id
lh = ws{[lakehouseId="lakehouse_id"]}[Data],
//replace table_name for the table you want to import
table = lh{[Id="table_name",ItemKind="Table"]}[Data]
in
table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment