Forum Discussion

jlammens's avatar
jlammens
Frequent Visitor
5 years ago
Solved

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...
Incremental Refresh
  • lbendlin's avatar
    lbendlin
    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's avatar
lbendlin
Super User
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.

jlammens's avatar
jlammens
Frequent Visitor
5 years ago

Yes, please point me to your blog entry. How do I get access to the XMLA endpoint?