Supermetrics for Power BI
Connect Microsoft Ads to Power BI — Search Advertising Dashboards
Build Power BI dashboards that unify Microsoft Ads and Google Ads search performance. DAX measures calculate cross-engine quality scores, blended CPA, and impression share gaps. Drill-through from campaign overview to keyword detail, published to Power BI Service for team access.
Why Connect Microsoft Ads to Power BI?
Build live Microsoft Ads dashboards in Power BI that update automatically and share with your team.
- Join Microsoft Ads and Google Ads in Power BI for cross-engine comparison. Shared slicers let you compare performance side-by-side.
- Create DAX for blended CPA, weighted quality scores, and impression share gap analysis. Measures update automatically with every refresh.
- Build drill-through pages from campaign to keyword, search term, and audience breakdowns within the same report.
How to Connect Microsoft Ads to Power BI
Three steps. Under two minutes. Zero code.
- 1
Open Power BI Desktop and Get Data
Launch Power BI Desktop, click "Get Data," and search for the Supermetrics connector to install it.
- 2
Authorize your data source
Sign in with your Supermetrics account and authorize your data source. Your credentials are encrypted and securely stored.
- 3
Build Your Dashboard
Select your metrics and dimensions, load the data into your model, and start building visuals, DAX measures, and interactive reports.
Dashboard Templates for Microsoft Ads in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Microsoft Ads Campaign Dashboard
KPI cards for spend, CPA, ROAS, and impression share with drill-through to keyword and search term detail. Budget pacing gauges.
Cross-Engine Search Intelligence
Unified Microsoft and Google Ads dashboard with shared slicers. Compare CPC, impression share, and conversion rates across engines.
Reporting Scenarios for Microsoft Ads in Power BI
Common reporting use cases that teams build with Microsoft Ads data in Power BI.
Clustered bar chart
Impression Share Comparison by Engine
Clustered bar chart comparing impression share and lost share across Microsoft and Google Ads for the same campaigns.
Heat map
Audience CPA Heatmap
Matrix heatmap with audience segments on rows and campaigns on columns, colored by CPA. Find the most efficient combinations.
What Microsoft Ads Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full Microsoft Ads reporting data — metrics and dimensions you already know from the Microsoft Ads interface.
Key Metrics
- Impressions
- Clicks
- Spend
- Conversions
- Revenue
- CPA
- ROAS
- CTR
- CPC
- Quality Score
- Impression share
- Average position
- Cost per conversion
- Conversion rate
- Assisted conversions
Key Dimensions
- Campaign name
- Ad group name
- Keyword
- Search term
- Match type
- Device type
- Network
- Location
- Age
- Gender
- Ad distribution
- Bid strategy type
Resources & Guides
14 Power BI marketing dashboard examples
Power BI for marketing: setup guide
Data transformation in Power BI
PPC reporting: extract insights from paid campaigns
Browse all Power BI templates
Feld Entertainment: enterprise dashboards
Why Supermetrics for Power BI?
The trusted marketing data platform since 2009. 200,000+ companies use Supermetrics — 15% of global ad spend flows through our connectors.
Built for Power BI
Purpose-built Power BI connector with setup in minutes. Your marketing team can build dashboards independently — no data engineering resources required.
170+ Data Sources
Connect Microsoft Ads alongside 170+ other platforms through a single integration. All your marketing data in one place.
Template Gallery
Start with pre-built Power BI dashboard templates for Microsoft Ads. Connect your account and have a polished, interactive report in minutes.
Enterprise Security
SOC 2 Type II certified. GDPR compliant. OAuth authentication. Your data is encrypted at rest and in transit.
Always Current
Your Microsoft Ads data refreshes automatically in Power BI. No manual exports, no stale numbers — open your report and the data is current.
No Data Limits
Query any date range, any number of campaigns, any level of granularity. No row limits, no sampling, no restrictions on the data you can pull.
Frequently Asked Questions
- Install the Supermetrics connector from the Power BI Desktop "Get Data" menu, sign in with your Supermetrics account, and authorize Microsoft Ads. Your data appears as a Power Query table — from there you load it into your model, build relationships, and start creating visuals. No custom connector development needed.
- Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Microsoft Ads data on the schedule you set — hourly, daily, or whatever cadence fits your reporting rhythm. Your dashboards stay current without manual intervention.
- Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Microsoft Ads alongside data from 170+ other marketing platforms — Google Ads, LinkedIn Ads, GA4, and more — then join them through shared dimensions like date, campaign name, or UTM parameters in Power Query or the data model.
- All standard Microsoft Ads reporting fields are available, including Impressions, Clicks, Spend, Conversions, Revenue, and more. You get the same data as the Microsoft Ads native reporting UI, loaded into Power BI where you can create DAX measures, build relationships, and apply row-level security.
- Basic Power BI Desktop knowledge is enough. Supermetrics handles the API connection, authentication, and data formatting. You pick your metrics, choose a date range, and load — the data arrives as clean tables ready for modeling. No API code, no ETL scripting.
- Yes. Pull both via Supermetrics into separate tables, create relationships on date and campaign name, and build visuals comparing performance across both engines.
- Pull Quality Score with daily granularity. Build a line chart by campaign or keyword, add a DAX measure for weighted average quality score over time.
Also Connect to Power BI
Ready to Connect Microsoft Ads to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.