Home > Destinations > Power BI > Impact.com

Connect Impact.com to Power BI

Connect Impact.com 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.

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

Used by the world's leading companies

Get Impact.com data into Power BI

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

Connect your data

Launch Impact.com 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 Impact.com.

Connect not only your Impact.com account but all your accounts too.

Start with a template

Ready-to-use Power BI dashboards

Move faster with templates built for reporting in Power BI.

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

Impact.com metrics and dimensions available in Power BI

Access 0 metrics and 165 dimensions from Impact.com connectors including , Program Name, Program State, Partner State, Ad Program Name, Ad Type, Landing Page, Deal Name, Deal Start Date, Deal End Date and more.

0

Available metrics

165

Available dimensions

How to connect Impact.com to Power BI ?

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

Step one

Authorize Impact.com

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

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

Impact.com 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.

Impact.com 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 impact.com to Power BI?

Connect the impact.com brand account in Catchr with its Account SID and Auth Token. Build a Power BI query for the available company, partner, program or ad metadata, preview it and import the generated URL through Get data > Web. Retain the relevant IDs so partner directories and program coverage can be modeled without counting each promotional property as a separate partner.

What impact.com data is currently available through Catchr?

The current connector exposes company information, partners, programs, ads, and details such as partner properties, promotional methods, and promotional countries. Use these fields to build a partner directory, review program coverage, or organize creative assets. They describe your partnership setup rather than transaction-level performance.

Can I report on impact.com sales and commissions with this connector?

The current Catchr field set does not include tracked actions, sales revenue, or commission payouts. A program setting such as view-through crediting or impression tracking does not provide the corresponding performance count. For a sales or commission dashboard, you need a separate performance dataset with those measures.

Can I group impact.com partners by promotional method or country?

Yes. Catchr exposes partner promotional methods, whether a method is primary, promotional countries, and partner properties such as websites or social profiles. These fields help review how your partnership network is structured. A partner can have several methods or properties, so count distinct partner IDs when measuring the number of partners.

Can I report on impact.com programs and creative assets?

Yes. Program IDs, names, states, and tracking settings are available alongside ad names, types, landing pages, and promotion dates. This can help organize banners, text links, and coupons. Creative metadata shows what an asset is and how it is configured; it does not show the clicks or sales generated by that asset.

Why does my impact.com partner count increase when I add dimensions?

Adding promotional countries, methods, properties, or program relationships can produce several rows for the same partner. A row count then measures combinations rather than individual partners. Use distinct partner IDs for a partner count and inspect a sample partner before interpreting totals in a more detailed table.

Can I combine impact.com partner information with other marketing data?

Yes. You can place partner information alongside sources such as Google Analytics 4 in one report. To connect partner records with website performance, use an explicit mapping from partner IDs to your tracking values. A shared dashboard alone does not attribute website conversions to impact.com partners.

How should I model impact.com partners in Power BI?

Use a partner table keyed by partner ID and separate tables for repeating promotional methods, countries or properties when needed. Count distinct partners rather than relationship rows. This model supports analysis of the partner network currently exposed by Catchr; it cannot calculate sales, commissions or return on spend when the imported dataset contains no such performance measures.

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