Skip to content

Instantly share code, notes, and snippets.

@pawarbi

pawarbi/Importing_Files_From_Lakehouse_PowerBI.pq Secret

Last active June 16, 2023 13:21
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/80aeb25c3772683c4ab2d06486be2238 to your computer and use it in GitHub Desktop.
Save pawarbi/80aeb25c3772683c4ab2d06486be2238 to your computer and use it in GitHub Desktop.
Download ZIP
Importing Files From Fabric OneLake Lakehouse In PowerBI
Raw
Importing_Files_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],
Files_Folder = lh{[Id="Files",ItemKind="Folder"]}[Data],
//replace folder_name if any
Files = Files_Folder{[Name="folder_name"]}[Content]
in
Files
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment