Limiting API calls for same information

[Wolly]

I have a function that's called within my Power Query that includes the API call similar to below:

https://eodhistoricaldata.com/api/eod/MSFT.US?from=2023-01-01&to=2023-01-01&api_token=YOUR_API_TOKEN

But where tickers and dates are variable based on other columns.....

Once it runs the query and populates the table the first time, is there a way i can prevent future calls for the same information?  Is there a way to add an If/then statement to look at said table, see if dates/data already exist and bypass the call?

thx much

[Wolly]

And this means what exactly?   Appreciate the reply but don't understand the explanation

[lbendlin]

Store the results of your API calls somewhere, and use your own process to keep track of which calls you have already made and which not.  Then point Power BI to the data for the reporting part.

[lbendlin]

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.