Forum Discussion
Download Lakehouse Files
Update of my problem:
All the technologies I've seen above (unless I'm mistaken) only serve to update and send new data to a Lakehouse, and that's not what we're looking for here.To answer my question, which is :
I need to make the files I've created available to colleaguesWell, to do this, I changed direction: OneLake
I had to assign specific and restricted roles, install OneLake on all the machines so that each PC then had access to the desired folder
By pushing the files into a new Lakehouse, a new workspace and managing the roles, I was able to export the data.However, I'm only keeping all this for development, I wouldn't recommend it for production.
I have other ideas for putting the export of Lakehouse files into production, such as with Power Pages, but as I can't find any way of extracting the files at the moment, the idea has been put off.
If anyone comes up with an alternative method, don't hesitate !
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
thank you for your quick reply!
I'm going to test and try with ADLS Gen-2 as I already have the GraphQL API ready.Thanks VIvMouret please keep me posted. This is intresting to learn about this usecase.
I've just tested your code, but I can't access the "files" properties
When I search in "Get data", I don't have direct access to the Lakehouse files
Will I normally be able to view the files in the Lakehouse?Because I can't see them..
I still need to check that I have read-only permissions for the API