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

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.