Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
IntaBruce's avatar
IntaBruce
Resolver I
4 years ago

Hi,
i've generated an API key and tried connecting but Power BI keeps giving this error:

What am I doing wrong?

  • mattlancs's avatar
    mattlancs
    Advocate II
    4 years ago

    Hi,

    It's hard to know without seeing the steps leading up to that error message - when you got to the bit asking how you want to connect to the web address, did you perhaps choose the Web API option for credentials? I only got it working using Basic credentials, as above. It's counterintuitive.

     

    Cheers,

    Matt

    • IntaBruce's avatar
      IntaBruce
      Resolver I
      4 years ago

      Thanks Matt, I should have read your instructions a little more carefully.  I've managed to connect now.  I just need to work out how to unpack the tables.

      • mattlancs's avatar
        mattlancs
        Advocate II
        4 years ago

        Good luck! Glad you're connected, and I can't fault you for assuming that Web API would be the straightforward option when you're trying to connect to an API...