Sync Lakehouse File Folder with Sharepoint Site Folder

[pcuriel]

Here is what I want to do (ideally):

1) End user loads file to a specific Sharepoint Folder.

2) Lakehouse gets access to this file (ideally through a shortcut to avoid data duplication, but duplication is not a deal breaker)

3) Spark Notebook processes the files in the Lakehouse File folder.

4) User gets access to the processed data through a shared semantic model.

The one thing I haven't figured out is how to do Step #2 other than registering an Azure App and doing API calls to move the data, but I'm trying to find a simpler solution.

[suparnababu8]

Hi @pcuriel 

Currently, fabric lakehouse doesn't support directly for Sharepoint access. I suggest you 2 ways

1) Use fabric data pipeline activity with Share point online or Https connector and then later push that files into Lakhouse as destination. 

 

2) You can use Dataflow gen2 to pull file from Sharepoint. But it supports structured, semistructred files only like excel,csv etc.

Think yourself and make good decission on this.

Pls let me know if it works.

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!