Forum Discussion
Export file to SharePoint
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
Is this what you are looking for?
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
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
6 Replies
Is this what you are looking for?
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
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!
I would use the Graph API with bulk insert. Probably using a Python library for sharepoint.
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
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?
