Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Stopping multiple API calls on same records from Power Query

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 

 

Need Help

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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?