Forum Discussion
API call runs twice
Hi all! I'm trying to create a Power Query that takes variables from an Excel Table and runs an API POST call. I get it to work, BUT for some reason, it runs the call twice each time. Since i...
Hi jos_ger ,
Power Query is not suitable for write back, as it will by default execute queries multiple times: The first execution is to retrieve metadata in order to create a query execution plan. After that it will execute the execution plan.
There is no way you can suppress that.
Easiest way would probably be to use a tool like Power Automate.