Data from Web - running multiple API call in the same query

[Markzolotoy]

My APIs require a token to access to. I have two other APIs that generate tokens. I would like to call token APIs before calling the actual data access API. But looks like the query only returns the result of the first call. If I use a similar technique in PowerBI Desktop than it works fine, but not in Excel. Any idea?

Thanks

[v-jingzhang]

Hi @Markzolotoy 

You can try converting the query which gets the token into a custom function, then call this function to get tokens in other queries for calling the actual data. 

Reference:

Web.contents unbale to authenticate with anonymous authentication - Microsoft Power BI Community

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!