Forum Discussion
jlammens
5 years agoFrequent Visitor
incremental refresh with Web.Contents not working
I have prepared a PBI M query using Web.Contents with RangeStart and RangeEnd parameters as described here which works fine in PBI desktop, but produces apparently unrelated errors in PBI Service (wi...
- 5 years ago
Exactly, it's just a warning, not an error message. If you know that your data source honors the RangeStart/RangeEnd parameters (in the appropriate format conversion ) then incremental refresh will work. The only sure way to validate incremental refresh is to look at the partition statistics in the XMLA endpoint. If you see only one partition then incremental refresh likely doesn't work. If you see multiple partitions then it works. I have a blog entry on that subject if you are interested.
lbendlin
5 years agoSuper User
You have to make sure that one of the parameters is inclusive and the other is not. so either updated_on_or_after or updated_on_or_before (but not both, and not neither).