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

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Having the same issue and never found a workaround. I experience the same speeds that Anonymous mentioned with no solution. I tried changing some of the option settings related to Data Load but that never showed any significant changes.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    There seems to be no Power Query solution with the standard SharePoint Online connector.

    If you can filter and bring in less than 5000 items, you can do a Odata feed which pulls in much much faster.

    As an example, I do

     

    let
    Source = OData.Feed("<SharePoint Site>/_api/web/lists/GetByTitle('<List>')/Items?$filter="
            &"Date eq '" & DateSearch() & "'")
in
    Source

    Where

    DateSearch()

    is a custom function to get the date.

    This might be enough for you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi DCM,

     

    Thanks for this solution, but for me this is not working. It is much faster though, but I miss the necessary columns.

     

    regards, Jordy

  • StephenF's avatar
    StephenF
    Responsive Resident
    6 years ago

    Same issue but with a .TSV stored in a sharepoint 365 documents folder.

     

    Takes ages to even start drawing down data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    We've been having identical issues for a long time - if there is a way to diagnose performance issues/bottlenecks, I'd love to see where things are slowing down.