Have you considered the Azure Data Factory? Sure, it has its shortcomings, but with it you can source your data from pretty much anywhere.

Truth be told, I've never did this exact type of load myself, but it appears that ADF has plenty of capacity sourcing the data from Sharepoint.