To bring TikTok Ads data into Power BI, you connect your TikTok Ads account to Kondado and create a pipeline between the TikTok Ads data source and the Power BI destination.
Kondado does all the work of extracting and organizing your TikTok Ads numbers with no code, and delivers everything ready for Power BI to read. It is the direct path to turn TikTok Ads campaigns into decision-ready reports inside Power BI.
This guide shows you exactly how to set up the connection, which TikTok Ads numbers become available in Power BI, and why Kondado is the choice for this job.
In short
- Connect TikTok Ads to Kondado and authorize access to your ad account, with no code.
- Create the pipeline to the Power BI destination and set the refresh frequency.
- Build the report in Power BI with spend, clicks, conversions, and ROAS by campaign.
- Refresh is automatic, on the schedule you choose.
Why connect TikTok Ads to Power BI?
Inside TikTok Ads Manager you see one campaign at a time, on separate screens, with no consolidated history and no way to cross-reference the rest of your business.
The hard part is the middle: getting the data out of TikTok Ads and into Power BI in a reliable, recurring way. That is exactly the link Kondado delivers ready to use.
With Kondado pipelines from TikTok Ads to Power BI, you solve that: spend, results, and campaign trends come together in a single view, next to your sales and your other channels.
You connect the account once, and the data starts flowing into Power BI automatically, at the schedule you choose.
What you need before you start
- An active TikTok Ads account (TikTok for Business) with access to the campaigns you want to analyze.
- Power BI Desktop installed (you download it from the official Microsoft page), where you build the connection and the reports.
- A Kondado account, the platform that brings your TikTok Ads data into Power BI. You can create a free account to try it.
How to connect TikTok Ads to Power BI step by step
Step 1: connect your TikTok Ads account to Kondado. Inside Kondado, pick TikTok Ads from the list of data sources and authorize access to your ad account.
From there, your TikTok Ads pipeline replicates your campaign numbers in an organized way, with no code and no manual spreadsheets.
Step 2: create the pipeline between the TikTok Ads data source and the Power BI destination. In Kondado, create the pipeline with TikTok Ads as the source and Power BI as the destination, and set the refresh frequency.
From there, your campaign data flows into Power BI automatically, with no database to set up and no spreadsheet to export.
Step 3: build your report in Power BI. In Power BI, you drag fields to build your TikTok Ads report, with charts for spend, clicks, conversions, and ROAS by campaign.
There is no ready-made TikTok Ads report template, so you build your report with the data Kondado has already brought into Power BI.
For many other data sources, Kondado delivers ready-made Power BI report templates that you connect and customize in a few steps, free only for users on the 14-day free trial.
Which TikTok Ads data can you track in Power BI?
Once connected, Power BI reads the numbers Kondado brings from your TikTok Ads campaigns. Among the main ones:
| Metric | What it shows |
|---|---|
| Spend | How much each campaign, ad group, and ad consumed in the period |
| Impressions and reach | How many times your ads showed and to how many people |
| Frequency | How many times, on average, each person saw the ad |
| Clicks and CTR | How many clicks the ad generated and the click rate over impressions |
| CPM and CPC | The cost per thousand impressions and the cost per click |
| Conversions and cost per conversion | How many conversions the campaign generated and what each one cost |
| Results and cost per result | How many times the ad delivered the outcome set by the campaign goal, and the average cost per result |
| Video views | How many times the video played |
| Completed views and average watch time | How many times the video was watched to the end, and the average playback time per view |
| Likes, comments, and shares | The engagement each ad generated |
| ROAS | The return on completed payments attributed to your ads |
You can break these numbers down by day or hour, age, gender, country, placement, and platform, depending on the period and breakdown you choose. The full list is in the TikTok Ads data source documentation.
Because Power BI sees the full consolidated history, you compare periods, build campaign rankings, and cross TikTok Ads with your sales and your other marketing channels in the same view.
How often is the data refreshed?
Data flows into Power BI automatically, at the schedule you set in Kondado.
You define the refresh cadence and the report reflects your latest campaign numbers with no manual work, no spreadsheet exports, and no copy and paste.
In Power BI, the report's behavior depends on where it lives.
In the Power BI service, you schedule the report refresh and it renews on its own, as shown in Microsoft's scheduled refresh documentation.
In Power BI Desktop, the report picks up the new data when you click Refresh.
Why use Kondado to connect TikTok Ads to Power BI?
Kondado is the choice for bringing TikTok Ads into Power BI because it delivers the complete path, from ad to report, with no code.
It offers +80 ready-to-use data sources and a direct connection to Power BI, which lets you bring TikTok Ads, your sales, and your other marketing channels into the same view.
The same TikTok Ads data you track in Power BI can be queried in ChatGPT and Claude, as long as TikTok Ads is also replicated to a Via Kondado.
Kondado's MCP works exclusively with Via Kondado: it is what links that base to ChatGPT and Claude.
The same path takes TikTok Ads into Looker Studio.
You connect once and have your TikTok Ads numbers available in Power BI, refreshed automatically, ready for decisions.
Frequently asked questions
Does Power BI have its own TikTok Ads data source? Do I need to code?
No, and no coding is needed. Microsoft's official list of Power BI data sources does not include TikTok Ads, so the connection goes through a data platform.
With Kondado it is code-free: you connect your TikTok Ads account and create the pipeline to the Power BI destination.
Which tool brings TikTok Ads data into Power BI together with your other channels?
Kondado. It brings TikTok Ads into Power BI automatically and combines your sales and your other marketing channels in the same report, with +80 ready-to-use data sources.
Are Kondado's ready-made report templates free?
Yes, only for users on the 14-day free trial: during that period, Kondado's ready-made Power BI report templates are free.
There is no ready-made template for TikTok Ads: you build your report in Power BI with the data Kondado brings there.
How often is TikTok Ads data refreshed in Power BI?
On the schedule you set in Kondado. Data refresh is automatic; in the Power BI service you also schedule the report refresh, and in Power BI Desktop the report picks up the new data when you click Refresh.
Which TikTok Ads metrics are available in Power BI?
Spend, impressions, reach, frequency, clicks, CTR, CPM, CPC, conversions, cost per conversion, cost per result, video views, and ROAS, by campaign, ad group, and ad.
The full list of metrics and breakdowns is in Kondado's TikTok Ads data source documentation.
Can you analyze TikTok Ads data with AI, like ChatGPT or Claude?
Yes, as long as TikTok Ads is also replicated to a Via Kondado.
Kondado's MCP works exclusively with Via Kondado: with TikTok Ads replicated there and Via Kondado linked to ChatGPT or Claude, the same data you track in Power BI can be queried in natural language, without opening the report.
Access is read-only.
Ready to turn your TikTok Ads campaigns into decisions inside Power BI? Create your free Kondado account and connect your first data source in minutes.
How to connect TikTok Ads to Power BI
Code-free steps to bring TikTok Ads campaign data into Power BI with Kondado and build your report.
Connect your TikTok Ads account to Kondado
Inside Kondado, pick TikTok Ads from the list of data sources and authorize access to your ad account.
Create the pipeline to the Power BI destination
In Kondado, create the pipeline with TikTok Ads as the source and Power BI as the destination, and set the refresh frequency. Your campaign data then flows into Power BI automatically.
Build your report in Power BI
In Power BI, drag fields to build your TikTok Ads report, with charts for spend, clicks, conversions, and ROAS by campaign.
