Writing data from Fabric to SharePoint Online

[vivien57]

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

[NandanHegde · Accepted solution]

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

[vivien57 · Accepted solution]

Hello,

It seems to be coming soon 🙂

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

[DiKi-I · Accepted solution]

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

[awbanksh]

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

[vivien57]

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

[Sephir]

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

[awbanksh]

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. 

[vivien57]

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

[NandanHegde]

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

[NandanHegde · Accepted solution]

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

[vivien57 · Accepted solution]

Hello,

It seems to be coming soon 🙂

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

[vivien57]

Hello,

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

Have a nice day,

Vivien