How Do I Get Google Analytics 4 to Power BI?

Getting your Google Analytics 4 data into Power BI opens up a world of powerful, custom analysis far beyond what GA4’s interface can offer. This article will walk you through the primary methods to connect GA4 to Power BI, outlining the step-by-step process for each so you can create the robust, interactive reports your team needs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect Google Analytics 4 to Power BI?

While the Google Analytics interface is great for quick check-ins, pulling that data into Power BI gives you some serious advantages. It allows you to merge your website analytics with other critical business data - like sales figures from your CRM, ad spend from marketing platforms, or customer data from your email service.

Here’s what you gain by making this connection:

• A single source of truth: Combine web traffic data with sales, marketing, and financial data to see the complete picture of your business performance in one dashboard.
• Advanced data modeling: Power BI’s flexible data modeling capabilities let you create custom relationships, calculated columns, and complex DAX measures that aren’t possible within the GA4 environment.
• Interactive, shareable reports: Build fully interactive dashboards with drill-downs and filters that you can securely share with stakeholders who don't have (or need) access to your Google Analytics account.
• Avoid data sampling: For high-traffic websites, the GA4 interface often relies on sampled data for complex reports. Connecting directly to the raw data in Power BI (especially via BigQuery) ensures you're analyzing a complete and accurate dataset.

Method 1: Using Power BI's Built-In Google Analytics Connector

The simplest way to get started is by using the native connector built directly into Power BI Desktop. This method is best for straightforward analysis and when you need to pull in a limited set of dimensions and metrics for a specific report. It connects directly to the GA4 API.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Open Power BI and Get Data: Launch Power BI Desktop. In the "Home" tab on the ribbon, click on "Get Data." This will open a dialog box with a list of available data sources.
2. Search for the Google Analytics Connector: In the "Get Data" window, type "Google Analytics" into the search bar. Select the connector and click "Connect."
3. Sign In and Authorize: You’ll be prompted to sign in to your Google Account. Choose the account associated with the Google Analytics 4 property you want to connect to. You will need to grant Power BI permission to access your Google Analytics data.
4. Navigate to Your GA4 Data: Once you are authenticated, the "Navigator" window will appear. Here, you'll see a list of all the Google Analytics accounts, properties, and views you have access to. Find the desired GA4 property and expand it. You will see folders containing hundreds of available dimensions and metrics.
5. Select Your Dimensions and Metrics: This is the most important step. Unlike other connectors where you pull entire tables, here you hand-pick the dimensions (like Date, Page Path, Session source / medium, Device Category) and metrics (like Sessions, Users, Conversions, Total Revenue) you need for your report. Check the boxes next to each item you want to import. A preview of the data table will appear on the right.

Pro-Tip: Be selective! The more dimensions you choose, the higher the risk of API limitations or slow load times. Start with a core set like Date, Sessions, and Users, and then add others as needed.

1. Load or Transform Data: After selecting your data, you can either click "Load" to import it directly into your Power BI model or click "Transform Data" to open the Power Query Editor. It's almost always a good idea to choose "Transform Data" to review data types, filter out unnecessary rows, and clean up your data before loading.

Limitations of the Native Connector

While this method is quick, it has a few drawbacks to keep in mind:

• API Quotas: The connection relies on the Google Analytics API, which has usage limits. If you request too much data or refresh too frequently, you might run into errors.
• Limited Combinations: You can only select a handful of dimensions and metrics in a single query. Requesting certain combinations that aren't compatible in GA4 will result in errors.
• Slower Performance: For large date ranges or complex data sets, this method can be slow to refresh as Power BI has to make API calls to Google for every update.

Method 2: Exporting GA4 Data to BigQuery and Connecting to Power BI

For businesses with high-traffic websites or complex analytical needs, this is the gold standard. By linking your GA4 property to Google BigQuery, you get a daily dump of your raw, unsampled, event-level data into a powerful data warehouse. You can then connect Power BI directly to BigQuery for best-in-class performance and flexibility.

This sounds technical, but it’s surprisingly straightforward to set up, and the BigQuery export itself is free for all GA4 properties.

Phase 1: Link Google Analytics 4 to BigQuery

1. Log into your Google Analytics 4 account.
2. Click on "Admin" in the bottom-left corner.
3. In the "Property" column, find and click on "BigQuery Links" under the "Product Links" section.
4. Click the blue "Link" button.
5. You'll be asked to "Choose a BigQuery project." If you already have one, select it. If not, follow the prompts to create one (it's free to get started).
6. Configure your settings. Select the data stream(s) you want to export and choose a reporting frequency. You can choose a "Daily" export (a batch file of the previous day's events) and/or a "Streaming" export (data is continuously exported within minutes of being collected). For most Power BI reports, the Daily export is perfect.
7. Click "Submit" to finish the linking process. Data will begin exporting to your BigQuery project within 24 hours.

Phase 2: Connect Power BI to BigQuery

1. Inside Power BI Desktop, go to "Get Data."
2. Search for "Google BigQuery" and click "Connect".
3. Sign in with the Google Account that has access to your BigQuery project.
4. Once authenticated, the "Navigator" will pop up, listing your BigQuery projects. Find the project you linked to GA4.
5. Inside the project, you’ll find a dataset named analytics_YOUR_PROPERTY_ID. Expand it.
6. Here you will see daily tables of event data, named events_YYYYMMDD. Select one of these tables to preview what the data looks like, but to get all the data, choose the main project / dataset folder. Click "Transform Data."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Working with Your GA4 Data in Power BI

Once your GA4 data is in the Power Query Editor, it rarely comes in a "report-ready" state, especially from BigQuery. You’ll need to do some cleaning and shaping to make it useful. This is where Power BI really shines.

Common Power Query Transformations

The raw event data from BigQuery is detailed but nested. Here are a few essential transformations:

1. Expand Nested Columns

Much of the valuable information in the BigQuery export (like page titles, UTM parameters, etc.) is stored in a nested column called event_params. You'll need to expand it.

• Find the event_params column and click the expand icon (two arrows pointing opposite directions) on the column header.
• Choose "Expand to New Rows." This separates each parameter for a single event into its own row.
• The column will now show records. Expand it again, and this time, Power Query will show you the fields inside, like key, and values for string_value, int_value, etc. You’re mainly interested in the key and the associated value columns.

2. Pivot the Event Parameters

After expanding, your data is long and narrow, with parameter names (the key) in one column and their values in another. You need to pivot this to get a usable table structure.

• Select the event_params.key column.
• Go to the "Transform" tab and click "Pivot Column."
• In the dialog, set the "Values Columns" to be event_params.value.string_value (or int_value / double_value as needed).
• Under "Advanced options," choose "Don't Aggregate" for the Aggregate Value Function.

This will create new columns for each unique event parameter, like page_location, session_id, and source, which is exactly what you want for building visuals.

3. Change Data Types

Power BI is good at guessing data types, but you should always double-check. Ensure that date columns (like event_date) are set to "Date," and numerical columns are set to "Whole Number" or "Decimal Number." This is crucial for creating accurate visuals and calculations.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Building Your First GA4 Report in Power BI

After you've cleaned and loaded your data, you can finally start building your report on the canvas. Drag-and-drop your newly created fields to build visuals.

Here are a few quick ideas to get you started:

• Sessions Over Time: Use a Line Chart with event_date on the axis and a count of session_ids in the values.
• Top Pages: Create a Bar Chart with page_title (from your pivoted parameters) and a count of Users as the value.
• Traffic by Source/Medium: Make a table using the source and medium parameter fields and metrics like Sessions and Conversions.
• User Location Map: Drag the country or city fields onto a Map visual.

Final Thoughts

Connecting Google Analytics 4 to Power BI empowers you to break free from the limitations of the standard GA4 interface. Whether you use the direct native connector for simpler tasks or the robust BigQuery method for large-scale analysis, bringing your data into Power BI allows you to create comprehensive, deep-dive reports that tell the full story of your business.

After walking through these multi-step processes, it's clear there can be a lot of manual setup and transformation involved in simply getting your reports built. This is exactly why we built Graphed . We automate the entire pipeline, connecting directly to Google Analytics and your other marketing data sources with one-click integrations. Instead of learning Power Query or worrying about BigQuery schemas, you can just describe the report you need in plain English, and our tool builds the dashboard for you in seconds, with live data that's always up to date.