Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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.
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.