Connect Xandr to Power BI

Microsoft announced that media buying through Microsoft Invest would no longer be supported from February 28, 2026. Catchr's Xandr integration reads advertiser reports; it does not restore campaign buying. Reporting on an existing account depends on the API access and data Microsoft still makes available to that account. Confirm those permissions before relying on a new dashboard. Campaigns moved to Amazon DSP need that platform's separate connection. If reporting access remains available, preview the Catchr query before importing its URL through Get data > Web in Power BI Desktop.

If your Xandr reporting access is active, add Xandr in Catchr using the username and password of an account with API access. Then open the Catchr Xandr connector in Power BI and select an accessible advertiser. Create a simple daily report first and compare it with an available Xandr export. Microsoft Advertising search credentials are for a different platform and cannot substitute for Xandr credentials.

The connector requests the Advertiser Analytics report for the selected advertiser. Its field catalog includes impressions, clicks, spend, conversions and video metrics, with campaign, insertion order, line item, creative, placement and deal dimensions. Use the ID alongside the name when comparing entities with similar names. This connection is not a general export of every Microsoft Monetize publisher report or every Xandr API dataset.

Microsoft's Advertiser Analytics documentation says creative, placement and brand detail is aggregated after 14 months. Older totals can therefore remain available without individual creative or placement rows. For historical comparisons, use a reporting level available throughout both periods. A connector cannot reconstruct detail that the reporting API no longer returns.

Spend Adv Curr reports advertiser spend in the advertiser's preferred currency; include Advertiser Currency beside it. Media Cost measures impression purchase cost and should not be treated as an interchangeable spend total. Use the same cost field and currency for both your dashboard and reference export, especially when combining advertisers.

Xandr exposes post-click and post-view conversions, while GA4 applies its own measurement and attribution rules. Separate those Xandr components before comparing them with GA4. Match dates and conversion events, and avoid adding the components to Total Convs again. Reporting several platforms together does not deduplicate the purchases they each claim.

Divide Imps Viewed by View Measured Imps to calculate viewability. Dividing by all impressions answers a different question because some impressions were not measured. Calculate the ratio from totals for the selected period, rather than adding daily percentages. Keep Video Completions separate: a completed video and a viewable impression measure different aspects of delivery.