Incremental refresh in power BI for web API data source

[abhishekde]

I have developed an API using FastAPI which returns temperature data for for every hour of a day. I imported this data in power BI desktop using Web option under new source. I added the parameters (RangeStart & RangeEnd) as mentioned in the official documentation and filtered the data based on these parameters and followed every step. I added the incremental refresh policies and published it to the power BI service. when I use the Base url with dyanmic parameters as source (for passing the date for incremental refresh) I get the following error on power bi service. How to incrementally refresh data on power BI service?

[lbendlin · Accepted solution]

1. Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

2. Your data source does not fold.  There will be minimal benefit from using incremental refresh even if you manually refresh individual partitions.