cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jigar1276
Helper I
Helper I

Incremental refresh for Web API

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.

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

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. 

 

View solution in original post

1 REPLY 1
RicoZhou
Community Support
Community Support

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. 

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!