Export file to SharePoint

[AbiNyk]

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. 

BR

[lbendlin · Accepted solution]

Is this what you are looking for?

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

[NandanHegde · Accepted solution]

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

[asjones]

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?

[lbendlin · Accepted solution]

Is this what you are looking for?

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

[MarkPalmberg]

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!

[lbendlin]

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

[MarkPalmberg]

FWIW, here's what Copilot recommends:

Got it! To transfer data from Microsoft Fabric to a SharePoint list, you can follow these steps:

1. 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
     .

2. Determine the SharePoint Site URL:

   • Identify the URL of the SharePoint site where your list is located
     1
     .

3. 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
     .

4. Authentication:

   • Choose the appropriate authentication method (e.g., Organizational account, Service Principal) and configure it accordingly
     2
     .

5. 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
     .

6. 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

1

2

3

.