Connect Hotmart to Power BI: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Hotmart
Power BI

How to Visualize Hotmart Data in Power BI

Kondado makes it easy to visualize Hotmart data in Power BI without writing code or managing complex infrastructure. You connect your Hotmart account as a data source, select the pipelines that matter to your business, and your information flows directly into Power BI. There are no intermediate databases to configure, so marketing and operations teams can focus on analyzing results instead of handling technical setup. Your dashboards stay current through automated updates on a configurable schedule, giving you fresh insights whenever you need them.

Kondado connects Hotmart to Power BI via a direct connection with 11 pipelines and 202 fields, including Subscribers, Sales History, and Subscription Transactions, updated on a configurable schedule to keep your reports current without manual work.

With Kondado, business users can turn Hotmart subscription records, commission details, and student progress into clear visual reports that support daily decision making. Whether you track recurring revenue, monitor affiliate commissions, or measure course completion rates, you get the visual data you need to grow your digital business.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

By bringing Hotmart data into Power BI, you can combine Sales History with Sales Commissions to see exactly which products drive the most profit and which affiliates contribute the strongest results. The Subscribers pipeline lets you visualize active and canceled subscriptions alongside revenue trends, helping you spot churn patterns before they impact your monthly income. If you sell courses through Hotmart Club, you can track Student Progress and Pages access to understand engagement, identify students who may need extra support, and optimize your course content for better completion rates.

Try out all the features for free for 14 days

Hotmart data available in Power BI

11
available pipelines
202
extractable fields

Available integrations

Integration Description
Subscribers Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions Records of subscription transactions, including fields such as transaction code, product ID, and commission value.
Subscribers
Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions
Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases
Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown
Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History
Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students
Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules
Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress
Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages
Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products
Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions
Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

Try out all the features for free for 14 days

How to create Hotmart dashboards in Power BI

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect your Hotmart data source

Log in to Kondado and add Hotmart as a data source by entering your account credentials. Select the pipelines you want to replicate, such as Subscribers or Sales History, so Kondado knows which information to prepare for your dashboards.

2
Select Power BI destination

Choose Power BI as your destination and use the Via Kondado connection to send your Hotmart data directly into your workspace. This creates a smooth path from your digital sales platform to your visual reports without any intermediate steps.

3
Build dashboards and configure refresh

Open Power BI and use your replicated Hotmart data to create custom dashboards that track subscriptions, commissions, and course progress. Set your update frequency to run on a configurable schedule, from every five minutes to daily, so your reports stay current automatically.

Access Hotmart data in Power BI and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Hotmart data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Hotmart data in Power BI automatically

How do I connect Hotmart to Power BI without technical setup?
Start by adding Hotmart as a data source in your Kondado account and authenticate with your credentials. Then choose Power BI as your destination and select the pipelines you want to work with, such as Sales History or Subscribers. Kondado delivers the data directly, so you can begin building dashboards in minutes through the Via Kondado connection.
What custom dashboards can I build with Hotmart data in Power BI?
You can build dashboards that track subscription revenue, affiliate commission trends, and course completion rates using pipelines like Subscription Transactions and Hotmart Club: Student Progress. Many teams create visual reports that monitor churn, compare product performance, and measure student engagement across different modules. These custom reports help marketing and operations teams make faster, more informed decisions.
How often does Hotmart data update in Power BI?
You choose the update frequency that fits your business, with options ranging from every five minutes to daily. Once configured, Kondado keeps your Power BI dashboards current through automated updates on your selected schedule. This means your reports always reflect recent sales, subscriptions, and commissions without manual refreshing.
Which KPIs should I track when visualizing Hotmart data?
Focus on metrics like active subscriber count, monthly recurring revenue, commission values by affiliate, and course completion percentages. By combining the Subscribers pipeline with Sales Commissions and Hotmart Club: Student Progress, you can visualize the full journey from purchase to product consumption. These KPIs help you identify top-performing products, spot at-risk subscriptions, and improve student retention.
Are there report templates available for Hotmart and Power BI?
Kondado does not offer pre-built report templates for this connection, giving you the freedom to design custom dashboards that match your specific goals. You can build visual reports that combine Sales History, Subscription Transactions, and student engagement data however you prefer. This flexibility ensures your dashboards answer the exact questions your business cares about most.
Can I share Hotmart dashboards with my team inside Power BI?
Yes, once your data is in Power BI, you can share dashboards and reports with colleagues across your organization using standard sharing features. Team members in marketing, finance, and operations can view the same updated metrics and collaborate on decisions. This makes it simple to align everyone around subscription trends, sales performance, and course progress.
Can I send Hotmart data to other tools besides Power BI?
Yes, Kondado lets you replicate Hotmart information to multiple destinations, including Looker Studio, Google Sheets, BigQuery, and PostgreSQL. You can also send data to MySQL, Excel, Redshift, SQL Server, and Amazon S3. This flexibility allows you to use Hotmart data across different reporting and analytics platforms depending on your team’s needs.

Try out all the features for free for 14 days