Forum Discussion
SharePoint Online slow refresh
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
Is it possible to have an official response on this?
Is it that the connector is just badly done, a fault on our sides, or something else?And yes Anonymous I notice the same with the slow connection speed. It is barely 400KB/s which is unacceptable.
To be clear: If I write a VBA SQL connection, it pulls it much faster.
Another thing: Go to SharePoint Online -> Your list -> Export to Excel. You will notice it pulls it much faster, so what gives with the slow PowerQuery connection?
I have the same issue, sometimes the download speed drops to 2 KB/s, so the 10 MB I'm trying to retrieve takes ages...