Forum Discussion

Rookie_2022's avatar
Rookie_2022
Frequent Visitor
11 months ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    11 months ago

    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.

Anonymous's avatar
Anonymous
Not applicable
11 months ago

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.