Robert Duke on 22 Jan 2024 19:39:03
There are multiple Web API's out there that require calling multiple API's in a certain order (e.g. Login, Request Data, Fetch data), or only allow a single login. Power Query has a nasty habit of choosing to go behind the scene and make calls to the API's which can break the sequence (e.g. By calling the Login API multiple time). It would be very useful to be able to define a section of the Power Query that must be treated as a single entity. This would allow us to control the calls to these multi-call API's.
e,g,
{Some Power Query}
START_ATOMIC
{Call Login API}
{Call Request Report/Data API}
{Call Get Results/Data API}
END_ATOMIC
{Some more Power Query}