Forum Discussion
SharePoint Folder Connector takes too long to refresh
I need to read several files inside a folder in SharePoint. They have the same structure, so I'm usuing the SharePoint Folder connector on PowerBI to do this. The amount of data is not so big, for no...
It's probably SharePoint throttling - it doesn't like the number of calls it gets with a large number of files. You could split up the queries into multiple dataflows and stagger the refresh times a bit as a workaround, or use a script to combine the files into a smaller number of files.
DataInsights
Super User
Super UserAnonymous,
Here's a technique that might help: