Home > Destinations > Power BI > Matomo

Connect Matomo to Power BI

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

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

Used by the world's leading companies

Get Matomo data into Power BI

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

Connect your data

Launch Matomo 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 Matomo.

Connect not only your Matomo account but all your Analytics accounts too.

Start with a template

Ready-to-use Power BI dashboards

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

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

Matomo metrics and dimensions available in Power BI

Access 102 metrics and 79 dimensions from Matomo connectors including Users, New Users, Returning Users, Conversion Rate, Conversions, Revenue, Bounce Rate, Avg. time on page, Date, Campaign Name, Campaign Source, Campaign Medium, Source - Medium, Channel Type, Page URL, Country and more.

102

Available metrics

79

Available dimensions

How to connect Matomo to Power BI ?

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

Step one

Authorize Matomo

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

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

Matomo 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.

Matomo 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 Matomo to Power BI with Catchr?

Configure the Matomo connection in Catchr and select the website to analyze. In Catchr’s Power BI query builder, select visits and actions by date 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 website and reporting time zone clear in the model.

Is there a free Matomo connector for Power BI?

Yes. Matomo provides an officially supported connector at no cost. Catchr offers another option when you want to manage Matomo alongside other marketing connections. Compare the fields and reporting workflow you need; a basic Matomo dashboard does not inherently require a paid connector.

Why do daily unique visitors add up to more than the monthly total?

The same person can visit on several days and appear in each daily count. A unique count for the month deduplicates across that period. Do not sum daily unique visitors and label the result as monthly unique visitors; use a measure calculated for the reporting period you want.

Can I compare Matomo traffic by campaign and channel?

Yes. Catchr exposes campaign name, source, medium and other campaign fields, as well as referrer and channel information. Keep your tagging conventions consistent so the same campaign is not split across spelling or capitalization variants. Separate untagged traffic instead of silently grouping it into a named campaign.

Can I report on Matomo ecommerce performance?

Catchr includes ecommerce revenue and average order value fields. They are useful when ecommerce tracking is implemented on the website. Check the tracking setup and compare a small sample of orders before relying on the dashboard; a connector cannot supply transactions the analytics system never recorded.

Why does Matomo not match my GA4 report?

The tools can differ in collection, consent handling, visit definitions, identity and filters. Match the website, dates and timezone first, then compare equivalent metrics. A Matomo visit and a GA4 session should not be assumed to be identical solely because both describe browsing activity.

Can I compare Matomo conversions with advertising cost?

Yes. Add Google Ads or another advertising source. Agree on a conversion definition and campaign mapping before calculating cost per result. Keep Matomo-measured website outcomes separate from the conversions an advertising platform attributes to itself.

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