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.

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.

    • EbyEaso's avatar
      EbyEaso
      Helper III
      5 years ago

      Does Incremental Refresh help in this situation? For share Point online list.

      • lbendlin's avatar
        lbendlin
        Super User
        5 years ago

        That's a great question.  What would you base that on?  Created Date? Last Modified Date?

         

        Incremental refresh is good if you have immutable data - pretty much the opposite of a sharepoint list which is supposed to be a living document with frequent changes.

         

        What you're looking for is differential refresh. Only update stuff that has changed/been deleted, and add new items. The Last Modified Date is perfect for that.  You could envision a pseudo differential refresh where you add the items that were last modified in the last x days, and then deduplicate the IDs. The caveat here would be that you would miss out on the deletions. Meaning in your sharepoint list you should never actually delete items, only change their status to flag them as "include/exclude"