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.
Hello all,
I have used Postman to run a query wiht Consumer Key in Postman, it works and gives correct result.
But when I used the same parameters and Consumer-Key, and used below m query to get the result, the query has been loading long and timed out eventually. Anyone could help? Thanks.
- grazitti_sapna
Super User
Hi Rookie_2022,
Try restructuring your query like this:
let
url = "https://api.maersk.com/products/ocean-products",
response = Web.Contents(
url,
[
Query = [
vesselOperatorCarrierCode = "MAEU",
collectionOriginCountryCode = "US",
collectionOriginCityName = "Houston",
collectionOriginUnlocCode = "USHOU",
deliveryDestinationCountryCode = "NL",
deliveryDestinationCityName = "Rotterdam"
],
Headers = [
#"Content-Type" = "application/json",
#"Consumer-Key" = "your-key-here"
]
]
),
json = Json.Document(response)
in
jsonInstead of query = "..." you should pass query params inside the
Queryoption ofWeb.Contents.Your header keys must be quoted correctly (e.g.
#"Consumer-Key").If the API requires POST, you’d need to use
Content = Text.ToBinary(...)instead ofQuery. (But from your Postman screenshot, it looks like GET).🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!The Method is GET. I just copied your code and replace the Consumer Key with my key. However it still timeout as below.
- Shahid12523
Community Champion
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)
