Skip to content

Instantly share code, notes, and snippets.

@pawarbi

pawarbi/Importing_Tables_From_Lakehouse_PowerBI.pq Secret

Created June 16, 2023 13:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pawarbi/398b11540a62b1c8fae43423e022383c to your computer and use it in GitHub Desktop.
Save pawarbi/398b11540a62b1c8fae43423e022383c to your computer and use it in GitHub Desktop.
Download ZIP
Importing Delta Tables From Fabric OneLake Lakehouse in Power BI Without SQL Endpoint
Raw
Importing_Tables_From_Lakehouse_PowerBI.pq
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