Home > Destinations > Power BI > TikTok

Connect TikTok to Power BI

Connect TikTok to Power BI and and make the most of your data with direct integration into Power BI. Discover how to transfer, analyze, and visualize your marketing data to support better, data-driven decisions.

TikTok query · Power BI format
Ready to refresh
TikTok One source
Saved query API URL
Power BI Web · Import
TikTok accounts One or several selected accounts
Reporting grain Date · campaign · ad set · ad
Fields Selected metrics + dimensions
Date range Last 28 days · example preset
Filters Optional · query-specific
Power BI mode Import through Web (Basic)
One saved URL represents one Catchr source. Multiple TikTok accounts can share the query.

Used by the world's leading companies

Get TikTok data into Power BI

A no-code connection that works in Power BI Desktop and in the Power BI service.

Connect your data

Launch TikTok reporting faster

Skip ODBC drivers and custom API scripts. The connection runs from your browser and Power BI, with nothing else to install on your machine.

Automate extraction

Always work with fresh numbers

Once the report is published, Power BI calls your Facebook Ads query again on the schedule you choose, so weekly reviews start from current figures.

More than just one source

Connect your entire stack. Not only TikTok.

Connect not only your TikTok account but all your Social accounts too.

Start with a template

Ready-to-use Power BI dashboards

Move faster with templates built for Social reporting in Power BI.

Use your TikTok data with ready-to-use dashboards for tracking performance, trends, and key indicators.

TikTok metrics and dimensions available in Power BI

Access 33 metrics and 33 dimensions from TikTok connectors including Video Views, Reach, Profile Views, Likes, Comments, Shares, New Followers, Average Watch Time, Watched Full Video Rate, Bio Link Clicks, Date, Title, Video ID, Created Time, Audience Country, Audience City Name, Audience Age, Audience Gender, Traffic Impression Source, Share URL and more.

33

Available metrics

33

Available dimensions

How to connect TikTok to Power BI ?

Four steps, from Catchr to a refreshed Power BI report.

Step one

Authorize TikTok

Connect TikTok in Catchr with a TikTok user that has access to the Social accounts you need, and make those accounts available for reporting.

Client A · Connected sources
5 sources ready
TikTok 3 advertising accounts Connected
Google Ads 2 advertising accounts Connected
Google Analytics 4 1 web property Connected
HubSpot 1 CRM portal Connected
Step two

Build and preview the query

Choose Power BI format, select TikTok, accounts, fields, date range, filters, and supported options. Preview the response, save the query, and copy its URL.

Step three

Use Get data > Web

In Power BI Desktop, choose Get data > Web, keep Basic selected, paste the complete Catchr URL, confirm, then load or transform the response.

Step four

Shape, model, and refresh

Clean the table in Power Query, add relationships and DAX measures, then publish the report and set its refresh schedule in the Power BI service.

TikTok to Power BIpricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

More Power BI connectors

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

TikTok to Power BI: FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect TikTok Pages to Power BI?

Authorize the TikTok account in Catchr with access to its profile and eligible business analytics. In Catchr’s Power BI query builder, select daily account activity and a separate video table and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping account activity dates versus accumulated video performance clear in the model.

Which TikTok organic metrics can I report on?

Catchr's TikTok Organic catalog covers account video views, profile views, likes, comments, shares and follower changes. Video-level fields include views, favorites, reach, watch time and full-video watch rate where TikTok makes them available. Add the video description or link to identify content, and check availability before using business-specific actions such as website clicks or lead submissions.

Does the selected date range show views received during that period?

It depends on the report. Daily account metrics describe activity for the selected dates. In the video report, Catchr selects videos by publication date and retrieves the counters TikTok currently returns for those videos. Those counters can include activity accumulated after publication. Do not compare a table of videos published last month directly with an account chart of views received last month.

Can I track TikTok follower growth over time?

Yes, where TikTok returns the relevant account insights. Use Daily Total Followers to show the audience size and Daily New Followers and Daily Lost Followers to explain changes. Do not sum daily follower totals across a month: that repeatedly counts the same audience. Keep an end-of-period follower total separate from followers gained or lost during the period.

Can I show TikTok audience demographics in my dashboard?

Catchr includes account audience distributions by age, gender, country and city where available. Build a separate chart for each distribution. These are aggregate audience breakdowns, not a list of identifiable followers or a combined age-by-city analysis. Missing or limited categories should not be treated as proof that no followers belong to them.

Why do my TikTok dashboard numbers differ from TikTok's analytics?

First compare the same account, reporting period and metric. Check whether the reference is daily account activity or the accumulated performance of selected videos. Also confirm whether a metric counts views or unique viewers, since repeated viewing can produce different totals. Recent processing and cached data can affect freshness; verify a completed period before investigating a persistent discrepancy.

Does TikTok Pages include ad spend or TikTok Shop sales?

No. This source focuses on account and content analytics. Use TikTok Ads for paid campaign reporting, TikTok GMV Max for GMV Max performance, and TikTok Shop for commerce data. You can place those sources in the same dashboard, but their views, attribution and revenue measures should remain clearly labelled.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.

Your next report should not start with five exports

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources