View Categories

Create an Access Token

An access token is the password Power BI uses to read your data sources. Creating one takes a minute, and you can revoke it at any time without touching your HubSpot account or your other tokens.

i
Each token is linked to your HubSpot user. Power BI signs in with the email address of your HubSpot account as the user name and the token as the password. Any HubSpot user who can open the connector can create tokens; you do not need administrator rights.

Step 1: Open Access Tokens #

  1. Open the connector in HubSpot.
  2. In the connector’s menu, select Access Tokens. The page lists every token you have created.
  3. Select Create token.
Access Tokens page with the Create token button

Step 2: Name the token #

  1. Enter a Label that tells you where the token is used, for example Power BI Desktop or Power BI service refresh.
  2. Optionally set an Expiry date. It cannot be changed once the token is created. If your administrator has switched on automatic expiry, a date is applied for you when you leave the field empty.
  3. Select Create token.
Create access token dialog with a label filled in

Step 3: Copy the token #

The Your new access token dialog holds the value, hidden behind dots.

  1. Select Copy to put the token on your clipboard, or Show if you want to read it first.
  2. Paste it straight into Power BI, or keep it somewhere safe, such as a password manager.
  3. Select Close.
Your new access token dialog, value hidden, Show and Copy buttons
⚠ Copy the token before you close the dialog. The connector never shows it again. If you lose it, revoke that token and create a new one.

Step 4: Check the list #

The new token is listed with its label, creation date, expiry date if it has one, and the status Active. Only active tokens can sign in.

Access Tokens list with the new token and its Active status

Use the token in Power BI #

Good practice #

  • Create one token for each place you use it, for example one for your computer and one for the Power BI service, so you can revoke one without stopping the other.
  • Treat a token like a password: do not put it in emails, chats or shared files.
  • Set an expiry date for tokens you only need for a while.