Power BI Google Analytics 4 (GA4) Dashboard Template

Power BI Google Analytics 4 Dashboard

This Google Analytics 4 Dashboard Report Template for Power BI helps you to visualize your own GA4 data in Power BI in a few clicks.

 

Follow the steps outlined below to get your data connected.

 

The template is available both as

 

Power BI Web Template

  1. Connect your Google Analytics 4 Data to Windsor.ai

    Connect Google Analytics 4

    Register for free or login if you already have an account.

  2. Choose Google Analytics 4 from the left-side menu, click on “Sign in to Google” then follow the steps in the pop-up to sign-in and grant the required permissions.
  3. Select at least one Google Analytics 4 account from the drop-down.
  4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
  5. Install the Power BI Web App

    Install Power BI Web App: Google Analytics 4 Overview Report

  6. Click on Connect in the Connect your data section
    GA4 - Connect your Data
  7. Enter your API Key from Step 4.
    GA4 - Enter your API Key

  8. On the next screen click on Sign In
  9. Your data should be loading now. Depending on your data size this may take a minute or two.

 

Power BI Desktop

  1. Connect your Google Analytics 4 Data to Windsor.ai

    Connect Google Analytics 4

    Register for free or login if you already have an account.

  2. Choose Google Analytics 4 from the left-side menu, click on “Sign in to Google” then follow the steps in the pop-up to sign-in and grant the required permissions.
  3. Select at least one Google Analytics 4 account from the drop-down.
  4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
  5. Download the Desktop Template

    Download Power BI Desktop Template: Google Analytics 4 Overview Report

  6. When opening the template, on the start screen, paste your API Key from step 4:

Api Key

 

 

Power BI Google Analytics 4 Dashboard Template: metrics and dimensions

Below are the predefined metrics and dimensions available in the template. However, you can any other field you need in the connection string.

 

Dimensions:

    • Date
    • Country
    • Device Category
    • Source

 

Metrics:

    • Sessions
    • Engaged Sessions
    • Engagement Rate
    • Conversions
    • Conversion Rate
    • Average Session Duration

 

The Power BI Google Analytics 4 dashboard template can be customized with > 500 different dimensions, breakdowns and metrics. Head here to see a complete list: available metrics and dimensions.

It queries the data through our connector and makes it available in real-time.

 

You might also be interested in…