Forum Discussion
Data Refresh Time - Share Point
Does Incremental Refresh help in this situation? For share Point online list.
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"
Yes,
That would be based on the Modifed date. My data us a living data in a archive library. So there will be no changes or deletion will be happen to the items.
So will the Power BI support for incremental refresh for the data from Share Point? While I was doinfg research on this I red something related to "View Native Query". Only if this option available for the data sourse then only the Incremental refresh will work.
Any idea?
I wrote a blog post about that a while back
Let me know how you fare!