Forum Discussion
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...
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
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?