cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
glennburnside
New Member

Integration with BambooHR

Does anyone have any experience in using BambooHR as a data source for Power BI? There's no built-in connector for it obviously, but we're not sure the best way to get data exported from BambooHR and into a data source we can use from Power BI.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: 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

View solution in original post

6 REPLIES 6

Re: 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

View solution in original post

nicolaskatz Advocate I
Advocate I

Re: Integration with BambooHR

Hi Deldersveld,

I would be very interested in the solution if you found any to easily integrate power BI to BambooHR

 

thanks,

hello789567 Helper I
Helper I

Re: Integration with BambooHR

Does anyone have any updates on this, or had any success? 

mattlancs Advocate I
Advocate I

Re: Integration with BambooHR

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

Re: Integration with BambooHR

Matt, thanks for following up with all of this detail.

mattlancs Advocate I
Advocate I

Re: Integration with BambooHR

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!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors