Stopping multiple API calls on same records from Power Query

[Anonymous]

I have a column that calls an API that converts IP addresses to a countries and cities. To achieve that, I use the Json.Documents(Web.Contents(url, [IsRetry = false])) method to get the response back. From the my understanding of the documentation, setting the IsRetry option to false means when the data is refreshed, it doesn't call the API again on older data. But that isn't working, and it still calls the API instead of using the cache.

Am I understanding it correctly? How would I solve this so that it only calls the API on new data after each refresh? 

Any help would be appreciated. 

@v-kelly-msft @mahoneypat 

[v-eqin-msft]

Hi @Anonymous ,

You may refer to:

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only

Best Regards,
Eyelyn Qin

[mahoneypat]

Are you trying to get incremental refresh functionality?  If so, the IsRetry parameter wouldn't work for that, and a different approach is needed (not straight forward).

Pat

[Anonymous]

I'm trying to have one API call per record in my tables. So when the dataset is refreshed again, the older record that already called the API should not call it again. Is that possible in Power BI or should I do it in the backend, something I would prefer not to?