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/
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...