Forum Discussion
Push data to fabric warehouse or onelake via api
Hello jdechaud,
Thank you for reaching out to the Microsoft Fabric Community.You can use the OneLake REST API to upload CSV or Parquet files from your local server to OneLake, which can then be used in a Fabric Warehouse or Lakehouse. Below are the steps and resources to help you:
- Set up authentication using Microsoft Entra ID.
- Use the OneLake API to upload files to your Lakehouse’s Files section.
- Load files into Delta tables for Warehouse or Lakehouse use via the Lakehouse Management API or Open Mirroring for continuous updates.
For your reference below are the official Microsoft links:
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.Hello jdechaud,
Thanks for your follow-up.
Yes, AzCopy can be used to upload files like CSV or Parquet to OneLake in Microsoft Fabric, but it does require Microsoft Entra ID authentication for secure access. You’ll need to set up an Entra ID application with appropriate permissions to authenticate AzCopy. Alternatively, you can explore the OneLake Access API or Open Mirroring for automated uploads.
Please refer following Offical Documentation: Authorize access to blobs & files with AzCopy & Microsoft Entra ID | Microsoft Learn
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a "kudos" to help others locate it easily.
Thank you.
Community SupportHello jdechaud,
Thank you for reaching out to the Microsoft Fabric Community.
You can use the OneLake REST API to upload CSV or Parquet files from your local server to OneLake, which can then be used in a Fabric Warehouse or Lakehouse. Below are the steps and resources to help you:
- Set up authentication using Microsoft Entra ID.
- Use the OneLake API to upload files to your Lakehouse’s Files section.
- Load files into Delta tables for Warehouse or Lakehouse use via the Lakehouse Management API or Open Mirroring for continuous updates.
For your reference below are the official Microsoft links:
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hello,
Thank you for your answer it will maybe helpful, I didn't know taht we have have to set up authentification by Microsoft Entra ID.
I saw that we can use AZCopy to send files on Fabric. We must also have Entra ID?
Regards,
- v-ssriganesh
Hello jdechaud,
Thanks for your follow-up.
Yes, AzCopy can be used to upload files like CSV or Parquet to OneLake in Microsoft Fabric, but it does require Microsoft Entra ID authentication for secure access. You’ll need to set up an Entra ID application with appropriate permissions to authenticate AzCopy. Alternatively, you can explore the OneLake Access API or Open Mirroring for automated uploads.
Please refer following Offical Documentation: Authorize access to blobs & files with AzCopy & Microsoft Entra ID | Microsoft Learn
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a "kudos" to help others locate it easily.
Thank you.
