Forum Discussion
Integration with BambooHR
BambooHR has a REST API. Try reviewing it for what you need and using it in a web request from Power BI: http://www.bamboohr.com/api/documentation
Does anyone have any updates on this, or had any success?
Hi there,
I've just managed to get it working, hopefully this will help you too.
You need two bits of information to make it work, your subdomain and an API key. The subdomain is whatever your company's address starts with, e.g. if the users log on to https://contoso.bamboohr.com, then it's contoso. This article says how to generate an API key.
Once you've got that:
- Get data > Web.
- URL: use the following, changing the subdomain bit: https://api.bamboohr.com/api/gateway.php/subdomain/v1/employees/directory
- For the credentials, you don't want the Web API option, but just select Basic. Put your API key in the Username field, leave the password blank. Obviously!
That will get you towards a table showing what everyone's ID is in the system and some basic user info. To get other details you have to change that /employees/directory part of the URL; you could replace it with /time_off/whos_out to find out who's on holiday today. This page looks to be the best source of what those different address endings could be. Good luck!
Cheers,
Matt
Matt, thanks for following up with all of this detail.
You're welcome - I'm sure I'll be searching for how to connect again in six months time so hopefully I'll come across my own instructions!
I'm able to connect to our Bamboo data in Power BI Desktop, but once I publish the report it won't refresh the data. The Power BI service says that "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." When I edit the credentials, it won't let me proceed without a password. Has anyone gotten around this issue?
I was able to enter "x" in the password field and connect for refresh.
In case it helps anyone else, 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!
This solution is the one that actually worked for me! Thanks!
Has anyone managed to access the BambooHR timesheet entries report in PBI? I think the issue is that it needs a date filter to create the report
