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.
Super UserHi 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
json
Instead of query = "..." you should pass query params inside the Query option of Web.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 of Query. (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!