Forum Discussion

EbyEaso's avatar
EbyEaso
Helper III
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
  • EbyEaso's avatar
    EbyEaso
    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
Super 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.

  • EbyEaso's avatar
    EbyEaso
    Helper III
    5 years ago

    Thnak You lbendlin  for the info and update. Appreciate it.

     

    So with that said currently there is no solutiuon for this type of issue? Even if I select only needed columns when transforming data, Power BI will go through all column availbale from list while refreshing?

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      Not just that, it will also traverse all lookup column relationships.

      • EbyEaso's avatar
        EbyEaso
        Helper III
        5 years ago

        ok, Thank You lbendlin . Apprecaite it.