Forum Discussion
SharePoint Online slow refresh
As the title says. I have seen this issue posted several times but never found anything that may help. My reports pull from both a SQL db and several SharePoint lists. The SQL dbs will import 100,0...
So I used this as work around and the refresh takes less than a Minute.
Im exporting every 7 mins the couple of sharepoint lists into a CSV file and dumping them into a shared drive, where I set up the PBI connections.
There is a few links out there for reference on this flow. This is what I used.
http://www.sharepointsamples.com/export-sharepoint-list-items-as-csv-using-microsoft-flow/
Have you tried this with a list/library with 100k+ items? Using PowerShell from my desktop I can quickly export list data, but I'm afraid of using Flow due to the possibility of getting throttled.
Once the report is set up, I'm hoping that an incremental refresh will help bridge the load time gap.