Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Bumping this

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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