Forum Discussion

mparravani's avatar
mparravani
Regular Visitor
8 years ago

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 ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Here's how I connected to our BambooHR data:

 

1. <Optional> Create a service account in BambooHR and grant permissions to all the required fields for your query as well as the ability to create custom reports. Your service account will also need to have appropriate licensing in Office365.

2. Create a custom report in BambooHR with the fields required. Note the report ID at the end of the address when viewing the report.

3. Generate an API key in BambooHR. Make note of this API key because you will need it later.

4. Open Power BI and Get Data > Web > Address: https://api.bamboohr.com/api/gateway.php/companyDomain/v1/reports/id?format=csv (filling in the companyDomain and report ID with your data) > Username: <API key> > Password: <blank>

5. Create your visuals and publish your report to the Power BI service. 

6. Refresh your data. If prompted, update the credentials for BambooHR using the Username: <API key> and Password: x.

 

Good luck to you!

  • rush's avatar
    rush
    Helper V
    4 years ago

    Anonymous Thank you very much.


    I managed to view the data but cannot refresh the data in the power bi service with basic authentification.

    Tried "" and x as the password and it fails each time.

    Please help.

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Are you using a data gateway to connect to BambooHR's API? Are you able to refresh the data in PowerBI Desktop? Have you made any changes to the report you are using to fetch the data?

Related content