Forum Discussion

JordanPearson's avatar
JordanPearson
Helper II
4 years ago
Solved

Pull data from Hubspot into PBI via API

Hi all,    We have an existing project to improve our reporting capabilities around the data we hold in Hubspot (CRM platform).    The biggest problem we face right now is that we don't have a co...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI JordanPearson,

    According to the error message, it seems like you directly input API key value into the data connector, right? AFAIK, this connector will require you to define what type of API key that sends to the API service. (normally they will be defined as 'key name' = 'key value' to use in the connector)

    Here is the sample query:

    let
    Source =
        OData.Feed(
            "<API URL>",
            null,
            [Headers = [
                #"ApiKey" = "<YOUR API KEY>"
            ]]
        )
in
    Source

    Notice: #"ApiKey" part can be changed, you can check the API document definition first.

    Regards,

    Xiaoxin Sheng

ReportBuilder07's avatar
ReportBuilder07
Helper III
2 years ago

Hi JordanPearson I know this reply is very late lol. As a workaround, maybe you can use a 3rd party connector, which also pulls the data directly from the API, but it a lot more user friendly. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Hubspot connector in the data sources list:

 

 

After that, just grant access to your Hubspot account using your credentials, then on preview and destination page you will see a preview of your Hubspot fields:

 

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

Ray_Brosius's avatar
Ray_Brosius
Helper III
2 years ago

JordanPearson ,

We moved to use Snowflake and as such there is a direct datasynch from Hubspot to out Snowflake instance.  Hubspot uses snowflake as it's backend and they use a synch technology which you have to sign up for from HS and pay, but it eliminates any extraction from HS.   We then can write queries against the Snowflake instance to get to any data.