Forum Discussion
Export file to SharePoint
Is this what you are looking for?
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
Based on my understanding, unfortunately as of today there is no native support to export data into sharpoint either in dataflow gen 2 nor in data pipelines.
You would have to use notebook/custom logic to do the needful
Is this what you are looking for?
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
I was just looking at this app for a different reason yesterday, lbendlin , but as it happens, we have a similar SharePoint use case in mind that we've been addressing with a PowerShell script.
Just to put some flesh around this: I have a list in a SharePoint site that I'd like to point to data in our Fabric instance. If *you* were to do this, how would you do it? I guess I'm mainly wondering about what the "file" would need to look like on the Fabric side for SharePoint to be able to read it into a list, and then how that stays refreshed.... Thanks for any thoughts you can spare on the matter!
I would use the Graph API with bulk insert. Probably using a Python library for sharepoint.
FWIW, here's what Copilot recommends:
Got it! To transfer data from Microsoft Fabric to a SharePoint list, you can follow these steps:
Set Up Your Connection in Dataflow Gen2:
- Go to Data Factory in Microsoft Fabric.
- Use Power Query connectors to connect Dataflow Gen2 to your SharePoint list.
Determine the SharePoint Site URL:
- Identify the URL of the SharePoint site where your list is located.
Connect Using Power Query:
- Use Power Query Online to connect to your SharePoint list. This will allow you to push data from Microsoft Fabric into the list.
Authentication:
- Choose the appropriate authentication method (e.g., Organizational account, Service Principal) and configure it accordingly.
Configure the Connection:
- In Data Factory, go to Settings > Manage connections and gateways.
- Add a new data source, select SharePoint as the connection type, and provide the necessary details such as connection name and URL.
Copy Activity:
- Configure a copy activity in your data pipeline to transfer data from Microsoft Fabric to the SharePoint list.
These steps should help you set up the connection and transfer data smoothly. If you need more detailed guidance, you can refer to the official Microsoft documentation
.