Forum Discussion
Data Refresh Time - Share Point
Hello Everyone,
I have a problem here. I'm new to the community and still learning Power BI
I have share point list connected to my PBI. Rerport works fine and all Visualization is good. But the problem is while refreshing it takes long time. On avarage 40 to 50 minutes.
I have connected two share point online list. One list is data input by users and my team verify the data and approves it then directly goes to another list whcih is archive. The archive folder now has arround 7000 items. That is 7000 rows. I downloaded the list from share point and verified the sixe and it shows only 1047KB. But while refreshing the data source in Power BI it shows around 45 MB. I filtered out unwanted column when transform.
Can anyone help me out here.
Thank You,.
11 Replies
Sadly that is expected behavior with sharepoint lists, especially when you have dozens of columns (and expecially lots of lookup columns).
General rule of thumb is to keep the list as narrow as you can, avoid lookup columns where possible (combine the tables in Power BI instead) and to keep row count below 5000.
Hopefully one of the upcoming Power BI versions will improve the performance of the list connector.
Not just that, it will also traverse all lookup column relationships.
