# Token in Power Bi

**URL:** <https://community.hubspot.com/t/token-in-power-bi/96780>\
**Category:** APIs & Integrations\
**Tags:** free\
**Created:** [December 27, 2023, 5:04pm UTC](https://community.hubspot.com/t/token-in-power-bi/96780 "2023-12-27T17:04:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![GNascimentoOli](https://avatars.discourse-cdn.com/v4/letter/g/77aa72/32.png) [@GNascimentoOli](https://community.hubspot.com/u/GNascimentoOli)\
**Post date:** [December 27, 2023, 5:04pm UTC](https://community.hubspot.com/t/token-in-power-bi/96780/1 "2023-12-27T17:04:34Z")

</div>

I created a private application, it generated a token, but I don’t know how to use this token in Microsoft’s Power Bi to extract the Hubspot data. How do I use the token in Power Bi?

---

<div class="post-metadata">

**Author:** ![GNascimentoOli](https://avatars.discourse-cdn.com/v4/letter/g/77aa72/32.png) [@GNascimentoOli](https://community.hubspot.com/u/GNascimentoOli)\
**Post date:** [December 27, 2023, 5:01pm UTC](https://community.hubspot.com/t/token-in-power-bi/96780/2 "2023-12-27T17:01:29Z")

</div>

Criei um aplicativo privado, ele gerou um token, mas não sei como usar esse token no Power Bi da Microsoft para extrair os dados do Hubspot.

Qual é a forma de usar o token no Power Bi?

---

<div class="post-metadata">

**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\
**Post date:** [January 3, 2024, 3:11pm UTC](https://community.hubspot.com/t/token-in-power-bi/96780/3 "2024-01-03T15:11:30Z")

</div>

@GNascimentoOli You might consider the [HubSpot Integration for Power BI](https://ecosystem.hubspot.com/marketplace/listing/powerbi), which is available in the HubSpot App Marketplace. By using the connector, you will be able to create an automated data refresh schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.

---

<div class="post-metadata">

**Author:** ![GRajput](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/grajput/32/102020_2.png) [@GRajput](https://community.hubspot.com/u/GRajput)\
**Post date:** [December 29, 2023, 11:38am UTC](https://community.hubspot.com/t/token-in-power-bi/96780/4 "2023-12-29T11:38:15Z")

</div>

Hi

Public app is available for the same. For alternative you can use google sheet in between. connect HubSpot with googlesheet and then connect googlesheet with power Bi

For more refrence ([CLICK HERE)](https://app.hubspot.com/ecosystem/40157461/marketplace/apps/marketing/analytics-data/powerbi)

This is also discussed before on community your can refer to the link metioned ([CLICK HERE )](https://community.hubspot.com/t5/APIs-Integrations/Export-to-Power-BI/td-p/545503)

Hope this will helps you out. Please mark it as **Solution Accepted & Upvote to help other Community member.  
Thanks!**

@GNascimentoOli

---

<div class="post-metadata">

**Author:** ![RanbeerMak](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ranbeermak/32/54306_2.png) [@RanbeerMak](https://community.hubspot.com/u/RanbeerMak)\
**Post date:** [March 19, 2025, 6:11am UTC](https://community.hubspot.com/t/token-in-power-bi/96780/5 "2025-03-19T06:11:07Z")

</div>

The Power BI connector to HubSpot has been upgraded to use HubSpot Private apps.

Why don’t you check out my GitHub?

> **[GitHub - ranmax123/powerbi-custom-connectors: Repo for storing custom data connectors for Power...](https://github.com/ranmax123/powerbi-custom-connectors)**
>
> Repo for storing custom data connectors for Power BI

Why don’t you give it a try?

Best  
Ranbeer M