Home > Destinations > Power BI > Teads

Connect Teads to Power BI

Connect Teads 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.

Teads query · Power BI format
Ready to refresh
Teads One source
Saved query API URL
Power BI Web · Import
Teads 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 Teads accounts can share the query.

Used by the world's leading companies

Get Teads data into Power BI

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

Connect your data

Launch Teads 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

One query per source, one model for all your ads

Create a separate Catchr query for Google Ads, TikTok Ads, or GA4, load each table, and relate them in the same Power BI model.

Start with a template

Ready-to-use Power BI dashboards

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

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

Teads metrics and dimensions available in Power BI

Access 56 metrics and 78 dimensions from Teads connectors including Impressions, Clicks, Clickthrough Rate, Budget Spent, Post Click Conversions, Post View Conversions, Video Completion Rate, Valid and Viewable %, Date, Campaign Name, Advertiser Name, Line Item Name, Creative Name, Device, Country Name, Website or App, Video or Display and more.

56

Available metrics

78

Available dimensions

How to connect Teads to Power BI ?

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

Step one

Authorize Teads

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

Client A · Connected sources
5 sources ready
Teads 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 Teads, 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.

YOUR NEXT REPORT

What you can build with Facebook Ads data in Power BI

Marketing performanceIllustrative data
Purchase value$38,400
Spend$12,000
ROAS3.20×
Purchase value & spend4 weeks
Week 1
Week 2
Week 3
Week 4
● Purchase value● Spend

ROAS and CPA as DAX measures

Define ROAS as purchase value divided by spend, and CPA as spend divided by purchases, once in the model, so every visual and filter uses the same calculation.

Teads to Power BI pricing

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.

Teads 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 Teads to Power BI?

Add the Teads source in Catchr using a reporting API key with access to the advertiser. In Catchr’s Power BI query builder, select Date, Campaign Name, Impressions and Budget Spent 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 Teads Ad Manager reporting scope and currency clear in the model.

Which Teads video and display metrics can I report on?

Catchr exposes Impressions, Clicks, Budget Spent, Video Starts, Video Completes and video quartiles, plus post-click and post-view conversions. Available breakdowns include campaign, line item, creative, device, country and website domain. Choose metrics relevant to the format: video completions are useful for video campaigns, while clicks and viewability can help assess display delivery. Field availability depends on what Teads returns for your campaign.

Can I measure Teads viewability and attention in Power BI?

The connector includes fields for measurable and viewable impressions, average in-view time, and Lumen attention metrics where Teads supplies them. Keep these measures separate: delivery, viewability, video completion and attention describe different aspects of exposure. A blank measurement field is not evidence of zero attention. Confirm that the measurement is available for the campaign before using it as a reporting KPI.

Which Teads spend field should I use in my dashboard?

Catchr offers Budget Spent, Total Ad Cost and Fee, as well as separate Budget Delivered fields. Use the field that matches the cost definition in the Teads report you are comparing against, and include the corresponding currency. Do not add every monetary field together: a total can already include amounts shown in other columns. Keep the chosen cost definition consistent when calculating CPC or CPM.

Why do my daily Teads numbers differ from Teads Ad Manager?

First match the advertiser, date range, filters, currency and exact metric. Then check the Catchr Timezone setting: the connector uses a fixed UTC offset, with UTC+01:00 as its default. A different offset changes which events fall into each reporting day. For conversion comparisons, also match Conversion Name and distinguish Post Click Conversions from Post View Conversions.

Why is a Teads advertiser missing from Catchr?

Check that your API key has access to the advertiser. Catchr builds its advertiser list from a Teads impressions report covering the preceding 360 days, so an advertiser without reportable activity in that period may not appear. A newly active advertiser can also take time to appear in the cached account list. If access and recent activity are confirmed, contact Catchr support with the advertiser ID.

Does the Teads Power BI report update in real time?

Catchr waits for Teads to generate the requested report. Power BI then imports the available response when its model refreshes; this is not a streaming feed. Configure scheduled refresh after publishing the model and test it in the Power BI service. Keep the report period visible and use completed periods for regular client comparisons.

Can I compare Teads with other advertising channels?

Yes. Add Google Ads and Facebook Ads to compare spend and delivery alongside Teads. Align currencies, dates and cost definitions. Keep platform-attributed conversions clearly labelled, because several platforms can claim the same sale; their combined conversion total is not a deduplicated count of purchases.

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