Incremental Refresh API

[PowerUser123]

If my connection to an API takes longer than 2 hours to do a full refresh on desktop, then there is no way for me to utilize incremental refresh in Power BI service as the time limit is 2 hours for non-premium users?

I have historical data stored dating to today. I would ideally like to incrementally refresh the api starting from today's date going forward.

The api has parameters for start_date and end_date. 

Is there a way for me to adjust something so that I can only incrementally refresh from a point of time and forward? If the date parameters are dropped, then the refresh will take longer than 2 hours to complete.

[Sam002]

Can you please provide details as to how you managed to implement incremental refresh using data from API. I am stuck at the data not being able to query fold. I came to see that it's possible to implement incremental refresh logic manually, but I don't understand how.

[amitchandak]

@PowerUser123 , There are ways to manage it using XMLA end point. But all those are applicable for premium.

In the case of pro, You can divide the table into multiple tables and append them together. In pro, you can publish the file with data and you can load the data on the desktop and do that