Forum Discussion
Data from Web - running multiple API call in the same query
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
1 Reply
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!
