Incremental refresh for Web API

[Jigar1276]

Hi,

Is there any possibilities to have incremental refresh for web API (e.g. JIRA APIs)?

I am using web APIs which have data of 10 years. As of now whole data of 10 years is refreshed on each refresh schedule.

Is there anyway I can implement incremental refresh so that:

- only new rows (last update date/time field is available in data source) are added in data set? 

- any old rows which are updated (last update date/time field is available in data source) are refreshed in data set?

Note: I am having "Pro Account".

Thanks in advance for any guidance.

[v-rzhou-msft · Accepted solution]

Hi @Jigar1276 

You may refer to this post to set Incremental refresh for your report built by Web API.

Post: incremental refresh with Web.Contents not working

Thought web data source doesn't support query folding from this blog. Exactly, it's just a warning, not an error message. 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.  

For reference: Incremental Refresh with Slow-Changing Source Data

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.