Forum Discussion
Excel Power Query API Get Call duplicating calls when loading
I am making an API call in Excel Power Query. The data comes into PQ, I parse and transform the data. The issue comes into getting the data out of PQ. If I try to save it as a table in the workshee...
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.