topic Re: Writing data from Fabric to SharePoint Online in Pipelines

Writing data from Fabric to SharePoint Online

vivien57 — Wed, 08 May 2024 10:08:20 GMT

Hello everyone,

With DataPipeline, do you have a procedure for uploading a file (csv or excel) to SharePoint Online with data present in Fabric (Warehouse or LakeHouse)?

Thank you in advance for your help,

Have a nice day,

Vivien

Re: Writing data from Fabric to SharePoint Online

NandanHegde — Wed, 08 May 2024 16:27:38 GMT

Based on my understanding, unfortunately data pipelines doesnt support Sharepoint online as a sink.

So it is not directly possible but you would have to integrate it with either other tools like logic apps or leverage notebook for the same

Re: Writing data from Fabric to SharePoint Online

vivien57 — Mon, 13 May 2024 09:10:43 GMT

Hello,

It seems to be coming soon 🙂

https://learn.microsoft.com/en-us/fabric/release-plan/data-factory#get-data-sharepoint

Re: Writing data from Fabric to SharePoint Online

vivien57 — Tue, 04 Jun 2024 13:10:50 GMT

Hello,

This link no longer points to the correct resource, has it been removed by Microsoft?

Have a nice day,

Vivien

Re: Writing data from Fabric to SharePoint Online

awbanksh — Mon, 31 Mar 2025 05:28:14 GMT

Use Dataflow Gen 2, it can use your Lakehouse as a source and SharePoint folder as a destination.

Re: Writing data from Fabric to SharePoint Online

NandanHegde — Mon, 31 Mar 2025 07:45:02 GMT

This is still in private preveiw, so there is still yime to go via this route

Re: Writing data from Fabric to SharePoint Online

vivien57 — Mon, 31 Mar 2025 12:49:39 GMT

There is no SharePoint Folder yet in the destination of a DataFlow Gen2

Re: Writing data from Fabric to SharePoint Online

awbanksh — Mon, 31 Mar 2025 14:10:09 GMT

The other option is to use a Dataverse table as a "bridge" and send your CSV data to Dataverse, then connect Power Automate to Dataverse to then convert it back to a CSV and upload to SharePoint.

Not the most ideal solution but it does work and I would argue it's more reliable than dataflow gen2 as it's not as performant in comparison.

Re: Writing data from Fabric to SharePoint Online

Sephir — Tue, 01 Apr 2025 05:40:27 GMT

I am also waiting for this feature, someone know about it ?

Re: Writing data from Fabric to SharePoint Online

vivien57 — Thu, 03 Apr 2025 05:47:03 GMT

In that case, I think it's better to wait for this, which should be available soon.

https://learn.microsoft.com/en-us/fabric/release-plan/data-factory#dataflow-gen2-output-destination-sharepoint-files

Re: Writing data from Fabric to SharePoint Online

DiKi-I — Thu, 22 May 2025 15:50:03 GMT

It is now available in dataflowgen2. You can use sharepoint as data destination.