PowerQuery connect to API

[cristian_PBI]

hi all

I'm having difficulties setting up powerquery to get info from an API. 

I use Postman and everything is working just fine. 

So from above I'm using the URL from the GET and add it in the URL below and I use the token and add it to the Headers as per below. 

I use Anonymous auth. 

This gives me the following error

I dont get it. Could you help ? 

I specify that in order to receive the token I do use another GET action (GetToken). but having this token this should work fine...

thank you !

[cristian_PBI]

Hello @v-jingzhang 

Thank you SO much. Worked like a charm! 

Regards 

crisitan 

[v-jingzhang · Accepted solution]

Hi @cristian_PBI 

It seems you are using the incorrect header paramter for token. Use Authorization rather than X-API-KEY and add "Bearer " before the token. You could refer to this link: powerbi - Where do I save token in Power BI web connection?

Other reference:

powerbi - How do I retrieve a bearer token from a service in Power BI?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.