BambooHrPQExtension

Power Query connector for BambooHR.

Installation

• Copy the extension file (BambooHrPQExtension.mez) into [Documents]/Power BI Desktop/Custom Connectors.
• Check the option (Not Recommended) Allow any extension to load without validation or warning in Power BI Desktop (under File | Options and settings | Options | Security | Data Extensions).
• Restart Power BI Desktop.

Usage

• Open Power BI
• Select File | Get Data
• Select Other, BambooHrPQExtension, then Connect

• When the dialog appears, supply the subdomain:

• Select the desired tables from the Navigator dialog

Contributors

• Craig Buchanan

References

• BambooHR API reference
• Power Query documentation
• Power Query samples
• Ben Gribaudo's Power Query M Primer
• Chris Webb's BI Blog - Custom Data Connectors