Download Lakehouse Files

Hi VIvMouret 

In Microsoft Fabric, data in your Lakehouse is automatically stored in OneLake (backed by Azure Data Lake Storage Gen2). Since you already created a GraphQL API layer, you should be able to query and download files through that endpoint. Your single-page React application can call the GraphQL API to list, extract, and download Lakehouse files.If your application and the API run within Microsoft Fabric or an environment that has direct access to Fabric resources, you do not need additional services.

https://learn.microsoft.com/en-us/fabric/data-engineering/connect-apps-api-graphql

https://community.fabric.microsoft.com/t5/Data-Science/How-to-get-lakehouse-files-into-Azure-Function/m-p/4073966

OneLake provides open access to Fabric items using ADLS Gen2-compatible APIs:

• Use OneLake URIs to reference files in your Lakehouse, e.g., https://onelake.dfs.fabric.microsoft.com/<workspace>/<item>.lakehouse/<path>/<fileName>

Assign appropriate permissions to your application in Azure (e.g., "Storage Blob Data Reader" role for ADLS Gen2)

Thanks 

VIvMouret 

Try this approach instead of Graphql :

Use the Microsoft Fabric REST API. This allows you to programmatically access and download files by authenticating your app via Microsoft Entra (Azure AD). The process involves:

1. App Registration: Register your application in Microsoft Entra ID, assign permissions (e.g., Lakehouse.Read.All), and obtain credentials (Client ID, Client Secret, Tenant ID).
2. Authentication: Use these credentials to obtain an access token for API requests.
3. File Access: Use the Fabric REST API to list files in the Lakehouse and construct URLs for downloading them.

https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api

Something like this :

import requests

file_url = "https://onelake.dfs.fabric.microsoft.com/<workspace>/<lakehouse>.lakehouse/path/to/file"
headers = {"Authorization": f"Bearer {token}"}

response = requests.get(file_url, headers=headers)
if response.status_code == 200:
with open("downloaded_file", "wb") as file:
file.write(response.content)
print("File downloaded successfully!")
else:
print(f"Failed to download file: {response.status_code}")

See if this is working 

Thanks 

VIvMouret Please accept the solution if this resolves your query, as it will help community to find the answer quickly