Forum Discussion
Super UserWriting data from Fabric to SharePoint Online
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
Hello,
It seems to be coming soon 🙂
https://learn.microsoft.com/en-us/fabric/release-plan/data-factory#get-data-sharepointIt is now available in dataflowgen2. You can use sharepoint as data destination.
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.
Super User
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