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 ...
Hi,
I had the same error, so I used the following steps:
1. Get Data--> Web --> Basic URL (make sure you have the https:// format as Bamboo specifies)
2. Basic for access web content and add on user name the API key and at password a password that you want) and then connect
The connection works, but make sure you play with PowerBI edit queries (e.g. pivot columns, transpose, etc..) to setup the format of the data so it can be easily used.
Hope this helps.