Adam Jones on 09 Mar 2016 06:11:52
Allow me to scope the data refresh to only refresh items that exhibit certain characteristics. EX) updated in the last X days, created in the last X days, etc.. I have a SharePoint list that has 100,000 rows and when we perform a data refresh it takes an EXTREMELY long time over the Enterprise Data Gateway. The list goes back to 2001 and so I actually don't need ALL items refreshed, but only ones recently edited/created. This would help our internal resources as well as your cloud resources by not having us send more data over the network than needed.
- Comments (3)
RE: "Scoped" data refresh
This is a no-brainer! How can years go by without any indication that it's even on the roadmap much less already implemented?
RE: "Scoped" data refresh
Yes, we need a way to merge data and refresh only the one source not multiple sources. then you could define your list to be two sources, one that contains all the rows before a breakpoint set in the M query and one that contains all the rows after that breakpoint, and set the refresh to occur only on part two. You'd still be stuck going through the entire database, but since you'd ignroe the 98% that was static it would be much faster than a full load.
RE: "Scoped" data refresh
This would be super useful and I'm surprised it's not a standard feature.