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.
Solved! Go to Solution.
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:
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!
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!
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.