Pull data from Hubspot into PBI via API

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