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

user_k's avatar
user_k
Frequent Visitor
1 year ago

Hello Cayshin - does the above strategy still work for you?
I'm trying to use the "Get all CLICK events" code in my Power bi report (via a new blank query, and adding the code + my Hubspot access token to the advanced query editor), but each time I try I get stuck on the "Edit Credentials" piece. I try using the Web Api credential option by adding my access key again, but get this error:

 

Do you have any advice? 

Cayshin's avatar
Cayshin
Frequent Visitor
1 year ago

Yes, it still works.

If you get the "Edit Credentials" prompt, you'll want to select the Anonymous option.

 

  • user_k's avatar
    user_k
    Frequent Visitor
    1 year ago

    Thank you Cayshin  - that does seem to work!

    I just need to figure why I get "Expression.Error: Evaluation resulted in a stack overflow and cannot continue." even when I reduce the limit from 1000 to 10.