Forum Discussion
Trouble with an API that requires a key
So I am having trouble with an api that require a key. In Power BI I go to det data from web, I enter the api web address/query hit ok. Then I hit Web API I enter my key then hit connect. The error message I get says A web API key can only be specified when a web API key name is provided.
The documentation for the api I am using says the following "Please note that API keys should be supplied with "Bearer " prepended (e.g. "Bearer your_key")" So I have tried just my key by itsel in the key space and I have tried Bearer then my key (I tried with and without quotes around my key) but I get the same error message. Very novice at using Power BI to get API data so any help is appreciated.
Hi appsac1 ,
I think you can try "Advanced" function in Web connector. Add Authorization in Http request header and then add Bearer token into the checkbox, it looks like below.
For reference:
Bring Data In Power BI Via APIs Using Basic Authentication
Here is a solved post with similar requirement like yours, I hope it could help you solve your problem.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi appsac1 ,
I think you can try "Advanced" function in Web connector. Add Authorization in Http request header and then add Bearer token into the checkbox, it looks like below.
For reference:
Bring Data In Power BI Via APIs Using Basic Authentication
Here is a solved post with similar requirement like yours, I hope it could help you solve your problem.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you this worked for me.
