Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I wish to consume a simple API which is only authenticated with a bearer token.
This works perfectly when done in Postman.
I cannot figure out why Power BI cannot authenticate it.
Anonymous: "We couldn't authenticate with the credentials provided. Please try again"
Web API: "A web API key can only be specified when a web API key name is provided."
Figure: API Url with Authoirzation token reflecting the working version in Postman
I have also attempted to do this using the advanced editor from a blank query and still cannot authenticate.
let
apiUrl = "https://api.**********/2.0/items",
options = [Headers=[#"Authorization"="Bearer *************************************************"]],
result = Web.Contents(apiUrl , options)
in
result
@ALean,
Please check the following similar blog about how to connect to web API with bearer token.
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
Regards,
Lydia
Thanks for the link v-yuezhe-msft.
That didn't work though.
The code on that blog is just a more complicated version of what I'm doing.
Since my bearer token is static, I don't need to request it dynamically everytime.
That blog outlines it as fundamentally being "table = Web.Contents(apiUrl , options)"
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.