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...
Hi Anonymous ,
Please check whether there existing any step in Power Query cosuming too much cpu or memory. And try to use Table.Buffer to improve the data load performance.
SharePoint Online List- Power BI - slow query update
Slow refresh of SharePoint list data
Best regards,
Yuliana Gu
Hi Yuliana,
I do not have anything complicated happening on my queries.
This issue is replicated just by: New query -> SharePoint list -> Browse to list. That is all I am doing and it takes forever.
Another issue may be that SharePoint pulls all the data before filtering, unlike SQL