Forum Discussion
SharePoint Online slow refresh
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/
Thanks Anonymous it seems that i's the only solution. Quite very disappointing that we must resort to such dramatic workarounds to get two Microsoft environment to talk to each other...
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.