Forum Discussion
Incremental refresh in power BI for web API data source
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?
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.
1 Reply
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.