Forum Discussion
Connect to Bamboo's REST API- Error"Web API key can only be specified when API key name is provided"
Hello, I'm relatively new to PowerBI, and am trying to connect to Bamboo's Open API (REST API). My workflow is going through PowerBI's "New Source" --> "web" --> in "basic" I enter Bamboo's ...
Managing to connect through web browser is great news.
If "https://[my API key ]:[email protected]/api/gateway.php/{my organisation subdomain}/v1/reports/{report ID}?format=JSON&fd=no" works, it means that [my API key] is your username and x is your password. Try doing it in basic authentication.
If you want to use it in Power Query, follow my tutorial here. You can look up Authentication string in your web browser. It will be something like Authentiaction = "Basic <some long string here>".
Let me know, if you have any questions.
I had the similar issue, tried put the {API Key} in User Name and {x} in password still got "We Couldn't authenticate with the credentials provided."