Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ok. Thank You lbendlin . Appreciatte your kind assistance. So there is full cure for this issue.

     

    Hopefully Microsoft will come with a cure for this in future updates.

     

    Thanks again.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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.