topic Re: Export file to SharePoint in Dataflow

Export file to SharePoint

AbiNyk — Thu, 10 Oct 2024 10:33:41 GMT

Hi,

How can i save/export files to Sharepoint folders from Fabric?

As far as i can see the folder connector in the dataflow is meant for reading data and not sinking data.

Re: Export file to SharePoint

lbendlin — Thu, 10 Oct 2024 17:20:18 GMT

Is this what you are looking for?

Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn

Re: Export file to SharePoint

NandanHegde — Fri, 11 Oct 2024 02:57:16 GMT

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

Re: Export file to SharePoint

MarkPalmberg — Fri, 28 Feb 2025 15:25:28 GMT

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!

Re: Export file to SharePoint

MarkPalmberg — Fri, 28 Feb 2025 15:33:42 GMT

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
  1
  .
Determine the SharePoint Site URL:
- Identify the URL of the SharePoint site where your list is located
  1
  .
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
  1
  .
Authentication:
- Choose the appropriate authentication method (e.g., Organizational account, Service Principal) and configure it accordingly
  2
  .
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
  2
  .
Copy Activity:
- Configure a copy activity in your data pipeline to transfer data from Microsoft Fabric to the SharePoint list
  3
  .

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

Re: Export file to SharePoint

lbendlin — Fri, 28 Feb 2025 23:24:20 GMT

I would use the Graph API with bulk insert. Probably using a Python library for sharepoint.

Re: Export file to SharePoint

asjones — Thu, 17 Apr 2025 22:21:26 GMT

I would think you could do it with Power Automate.

I can pull data from a Power BI visual and Export it to a location with Power Automate.

Have you tried that?