Forum Discussion
SharePoint Online slow refresh
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
Bumping this
Will bump again.
Surely others using SharePoint Online have the same concern with how the standard PowerQuery (Excel & BI) downloads so much in file size and so slowly?
Again in Excel it can be worked around but not in BI as far as I can see, so refreshing datasets will just get slower and slower.
It seems that SharePoint online will not filter the data on the standard query until it has all been downloaded. I can see this by, in preview, when I filter a column and find it downloads the same file size again before completing the filter
Im having the exact same issue,
Origionally i thought it was an old powerbi file with too much going on (queries etc) so i started one from fresh to just use two lists and its unbearably slow, the download from sharepoint to powerbi is going at a rate of 500Kb/s (it aint my connection ive tried from two very good internet connections)
How the hell am i supposed to do very simple reports on large lists? (its over 30000+ entries)
Anonymous wrote:Will bump again.
Surely others using SharePoint Online have the same concern with how the standard PowerQuery (Excel & BI) downloads so much in file size and so slowly?
Again in Excel it can be worked around but not in BI as far as I can see, so refreshing datasets will just get slower and slower.
It seems that SharePoint online will not filter the data on the standard query until it has all been downloaded. I can see this by, in preview, when I filter a column and find it downloads the same file size again before completing the filter