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
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!