Suggest best way to connect SharePoint to Fabric ??

The SharePoint site contains folder like structure say year/month/date in that (list of files) and files are incrementally added every day so how to load the data in same format in Fabric

Option 1: By creating a connection( with tenant details) using copy data can able to load only the schema of the files in the lakehouse not the physical tables

Option 2: Using the dataflow gen2 failed to run the query as the data for the one month is more then 5GB

Please suggest an optimise way to connect SharePoint of fabric

5 comments