Forum Discussion
Solved
API Power Query
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 ...
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.
Hi Rookie_2022 ,
Just checking back were you able to test the API outside of Postman (like in a browser or with curl) as suggested? Knowing the outcome there will really help narrow down if the timeout is on the Power Query side or with the API itself.
Regards,
Akhil.