Power BI using Sharepoint list data source is taking about 1 hour to update

[RaphaelAlves]

I have a BI report connected to a Sharepoint list data source that is taking about 1 hour to update. It's a sharepoint list with 10,000 lines actually.

Is there a way to improve the update perfomance?

[v-yalanwu-msft · Accepted solution]

Hi, @RaphaelAlves ；

1.The article lists some useful tips, Try clicking Options-> Data Load-> Unclick all the options in Background Data, Time intelligence and Relationships, do click the Parallel loading of tables like below:

2.Please check whether there existing any step in Power Query consuming too much CPU or memory. And try to use Table.Buffer to improve the data load performance.

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)

3.Use DAX studio/ Performance Analyzer to check out which's the most time-consuming:

Follow this blog to install the dax studio,then connect the opened pbix file in dax studio

https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

4.Try updating the PowerBI version.

Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.