Home > Destinations > Power BI > Google Analytics

Connect Google Analytics to Power BI

Connect Google Analytics 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.

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

Used by the world's leading companies

Get Google Analytics data into Power BI

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

Connect your data

Launch Google Analytics 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 Google Analytics.

Connect not only your Google Analytics 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 Google Analytics data with ready-to-use dashboards for tracking performance, trends, and key indicators.

Google Analytics metrics and dimensions available in Power BI

Access 81 metrics and 207 dimensions from Google Analytics connectors including Sessions, Active users, Conversions, Total revenue, Engagement rate, Return on ad spend, Session source / medium, Session campaign, Default channel group, Google Ads campaign, Region, Month of the year and more.

81

Available metrics

207

Available dimensions

How to connect Google Analytics to Power BI ?

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

Step one

Authorize Google Analytics

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

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

Google Analytics 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.

Google Analytics 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 GA4 to Power BI with Catchr?

Authorize Catchr with a Google user who can access the GA4 property and select that property. In Catchr’s Power BI query builder, select sessions and engagement 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 property and compatible session, event and user dimensions clear in the model.

Does Power BI have a native Google Analytics connector?

Yes. Microsoft provides a Google Analytics connector in Power Query with GA4 support. Catchr offers another route when managing analytics alongside advertising and other sources fits your workflow. Compare the required fields, account setup and reporting behavior. Both routes still depend on the analytics data made available by Google; neither automatically reproduces every Exploration.

Which GA4 metrics should I use for an acquisition report?

Use sessions to measure visits, engaged sessions to assess visit quality, and revenue where ecommerce tracking is configured. Pair those with session source and medium for a visit-based acquisition view. Active users answer a different question: how many distinct active people were measured. Catchr's GA4 fields include these metrics and session-level traffic-source dimensions.

Why do my user totals change when I add daily rows?

A person who visits on several days can appear in each daily count but only once in a distinct-user total for the whole period. Adding daily user counts therefore does not produce the period's unique users. Keep a separate scorecard for the full date range and use the daily chart to show the trend.

Why does my Power BI report differ from a GA4 Exploration?

Align the property, dates, filters, metric definition and dimension scope. Catchr retrieves reporting data, while an Exploration can use a different configuration or population. Compare sessions with sessions and active users with active users, and inspect the rows before adding DAX measures or relationships. A one-to-many join or a sum of daily unique users can introduce an additional difference inside the Power BI model.

Can a connector remove GA4 API quota limits?

No connector can promise to bypass Google's property-level API quotas. Complex requests, many charts and frequent reloads can consume the available allowance. Reduce unnecessary charts and long date ranges, reuse data sources where practical and allow exhausted quotas to recover. A connector subscription and Google's API capacity are separate constraints.

Can I compare GA4 results with advertising spend?

Yes. Add Google Ads or your other advertising sources to the report. Agree on campaign naming, dates and currency before creating relationships. Use the result to compare acquisition cost with website outcomes, while keeping GA4 attribution distinct from the conversions each advertising platform claims.

Should I use session source or first user source?

Use session source when you want to explain which channel brought a visit. Use first user source when you want to describe how a user was first acquired. These answer different questions, so give charts clear titles and avoid swapping one dimension for the other when comparing campaign performance.

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