Home > Destinations > Power BI > Microsoft Ads

Connect Microsoft Ads to Power BI

Connect Microsoft Ads 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.

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

Used by the world's leading companies

Get Microsoft Ads data into Power BI

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

Connect your data

Launch Microsoft Ads 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 Microsoft Ads data with ready-to-use dashboards for tracking performance, trends, and key indicators.

Microsoft Ads metrics and dimensions available in Power BI

Access 67 metrics and 190 dimensions from Microsoft Ads connectors including Spend, Clicks, Impressions, Conversions, Revenue, Return On Ad Spend, Cost Per Conversion, Conversion Rate, CPC, Ctr, Account Name, Campaign Name, Campaign Type, Campaign Status, Ad Group Name, Ad Group Status, Keyword Id, Device Type, Country, Network and more.

67

Available metrics

190

Available dimensions

How to connect Microsoft Ads to Power BI ?

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

Step one

Authorize Microsoft Ads

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

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

Microsoft Ads 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.

Microsoft Ads 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 Microsoft Advertising to Power BI?

Authorize Microsoft Advertising in Catchr and select the intended advertising accounts. In Catchr’s Power BI query builder, select spend, clicks and conversions by campaign 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, currency and conversion goal clear in the model.

Is the Bing Ads connector the same as Microsoft Ads?

Bing Ads is the former name of Microsoft Advertising. You may still see Bing in technical field or connector references. Select the Microsoft Advertising account you manage and verify its account ID, rather than treating the older name as a separate advertising platform.

Why are Conversions and All Conversions different?

Microsoft can exclude goals from the main Conversions measure when those goals are excluded from bidding. All Conversions provides a broader view. Catchr exposes both fields. Choose the measure that matches the business objective and keep that choice consistent in your cost-per-conversion calculations.

Can I compare Microsoft Ads with Google Ads in one report?

Yes. Add Google Ads to compare spend, clicks and results across search platforms. Align currency, dates and conversion definitions. Similar field names do not guarantee that both platforms count the same goals or use the same attribution rules.

Why do my Microsoft Ads conversion totals change later?

A conversion can happen after the ad interaction, and processing or attribution can update recent results. Compare the same date range and goal selection when reconciling a later export. Treat the newest period as provisional instead of assuming that every refresh must reproduce yesterday's total.

How should I calculate an overall CPC or conversion rate?

Divide total spend by total clicks for CPC. For conversion rate, use the appropriate conversion total and click denominator for the definition you selected. Do not average campaign percentages without weighting them; small and large campaigns should contribute in proportion to their underlying activity.

Can I separate view-through conversions from click-based results?

Catchr includes a View Through Conversions field alongside the other Microsoft Advertising conversion measures. Show it separately when explaining the contribution of ad exposure. Do not add overlapping measures together without checking their definitions, or the dashboard can count the same outcome more than once.

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