Forum Discussion

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago
Solved

Slow refresh of SharePoint list data

Hi everybody,   I have a dashboard that is getting data from multiple SharePoint lists. Some of these lists contain around 3000 to 4000 lines. When I want to refresh my dashboard it takes about 3 m...
Need Help
  • ImkeF's avatar
    ImkeF
    9 years ago

    Yes, pls try that.

    Fetch your raw-data in one query and then reference this query. This will create a first step like so:

    Source = NameOfTheQueryWithRawData

     

     

    Change that step into this:

    Source = Table.Buffer(NameOfTheQueryWithRawData)

     

     

     

    Unfortunately, there's not much informations available around performance tuning at the moment (here are some additional details: https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/)