Forum Discussion
Excel Power Query API Get Call duplicating calls when loading
Power Query itself is not the storage for the data, it only transforms it. You may see result of the transformation in Power Query Editor in preview mode. To keep transformed data you need to load result into the grid and/or data model. Each time you load or refresh data Power Query repeats evaluation again.
Table.Buffer is mainly to fix some steps in the memory to avoid partial re-evaluation, but that's to make next steps more reliable.
SergeiBaklan Thank you for clarification. Is there no way to make the call from the source and stop future calls for the same data while you transform and load the data already sourced?
Based on your sample file you have now field which could indicate that's old or new data, like Date. Thus you have to reload everything from scratch.
- Sergei, thank you for looking into my challenge. I am only querying the data from the API as a source. I want to transform that data and then analyze the data brought in. I do not want it to go back to the source for any updates. it is a one time pull of the data. My challege is that when I make an API call, it pulls the data from the source API. I transform that data. When I attempt to pull that data into a table or put it into the data model, the source (the api) is called again by Power Query instead of just using the cache data it had already pulled and transformed. I am going over my quota for api calls because it is doing this. I am trying to stop the additional api calls back to the source and only use the data pulled the first time.