I am trying to connect our HubSpot account to Power BI so that data retrieval can be automated instead of manually exporting data to Excel.
I have Super Admin access to the HubSpot account. The HubSpot application was originally set up by another member of our company, and I am now trying to access the data programmatically through the HubSpot API.
I attempted to use credentials available in the Developer section and followed the HubSpot API documentation, but my API requests return an “invalid credentials” error.
I would appreciate guidance on the following:How can I properly set up API access for this HubSpot account so that Power BI can retrieve data automatically?How can I obtain the correct authentication credentials (Private App token, access token, or other supported method) for this account?What is the correct API endpoint URL format and authentication method required for connecting HubSpot data to Power BI?Are there any specific permissions or scopes that need to be enabled for API access?
Any assistance or direction to the appropriate technical documentation or support team would be greatly appreciated.
Hey @SGopakumar2,
Welcome to the Community!
It’s possible you could be using credentials from your Developer account, which are meant for building apps instead of direct API access. Tagging in some of our Top Contributors to see if they have any specific suggestions for you!
Hey @evaldas, @MichaelMa, @Josh -- Do you have any suggestions for @SGopakumar2 on this?
Thank you!!
Sam, Community Manager
I would recommend using Service Keys for HubSpot API operations. The scopes you select depends on what kind of data you will want to work with (i.e. Contacts, Companies, Deals) and whether you want read or write access - I would avoid selecting all scopes by default.
I assume you will likely be working with CRM data, so there are individual endpoints available for all the objects: Understanding the CRM APIs - HubSpot docs
You would likely need to delve deeper into how the integration was set up.
Going over the easy stuff first. If you want to access stuff via the API, you can either use your own Personal Access Key found at Development → Keys → Personal Access key. Be super careful with this as it will have access to everything. In most cases, you would use this with the hs cli.
You can also create a Legacy App Key or Service Key (Settings → Integrations) to grant specific access based on scopes. These usually will be accessed via the Bearer token method instead of oauth. Using something like Postman, you can use the Bearer Token for authentication and test endpoints. HubSpot has their API documents in Postman which makes it easier.
You can see all the endpoints via the API documentation: 2026-03 API reference - HubSpot docs
As for how to set up PowerBI to access HubSpot, that is up to you and how you want to set it up and not something we really can help with unless you already have an idea on how you want to set it up.
There’s an app in the marketplace: HubSpot Marketplace which might be a good place to start.