Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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 Zhou
If 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.
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 Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |