Forum Discussion
API Power Query
Hey Rookie_2022 ,
Thanks for sharing the updates. Since Postman works fine but Power Query is still timing out, it might be more of a connectivity or header handling issue inside Power BI. A couple of quick checks you could try:- Make sure "Consumer-Key" is quoted exactly in the headers.
- Pass the query parameters under Query = [...] instead of as a separate record.
- Try adding a longer timeout with Timeout = #duration(0,0,3,0).
- If possible, test the same URL (with parameters) directly in a browser or using curl that will confirm whether the timeout only happens in Power Query.
Did you get a chance to try calling the API outside Postman (like in a browser)? That would help narrow down if the issue is with the API itself or just how Power Query is handling it.
Regards,
Akhil.
Your Power Query is timing out because it’s likely missing the "Method = "POST" declaration. Power Query defaults to GET unless told otherwise. Add this inside your Web.Contents call:
Method = "POST"
Also make sure:
- Headers are correctly formatted ("Content-Type" and "Consumer-Key")
- Body is converted with Text.ToBinary(Json.FromValue(body))
- You can optionally extend timeout with Timeout = #duration(0,0,3,0)
