Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
vivien57
Kudo Collector
Kudo Collector

Writing data from Fabric to SharePoint Online

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

3 ACCEPTED SOLUTIONS
NandanHegde
Super User
Super User

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

DiKi-I
Post Patron
Post Patron

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

DiKiI_0-1747929133846.png

 

View solution in original post

10 REPLIES 10
DiKi-I
Post Patron
Post Patron

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

DiKiI_0-1747929133846.png

 

awbanksh
Microsoft Employee
Microsoft Employee

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

vivien57_0-1743425342576.png

 

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

 

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

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. 


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

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
NandanHegde
Super User
Super User

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Hello,

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

Have a nice day,

Vivien

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.