• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / Google Analytics / Export Google Analytics data to Microsoft Power BI
Export Google Analytics data to Microsoft Power BI

Export Google Analytics data to Microsoft Power BI

posted on October 20, 2015

If you need more control of your data and you always wanted to download it to Excel, you can now do that with Microsoft’s supercharged Excel program: Power BI Desktop.

I will guide you through the initial steps to get Google Analytics data into Power BI so you can create reports like this:

About the report

The following Power BI report app will allow you to connect to Google Analytics 4 to analyze your website performance.
The report contains 7 tabs to analyze different aspects of your website:

  1. The User Acquisition Page, will allow you to get a deeper understanding on how your new users reach your site.
  2. The Traffic Acquisition Page, will help you understand where your traffic comes from for new and return users.
  3. The Pages page, lets you analyze your content so you can improve it or create more of what is working already.
  4. The Landing Page , will help you understand which pages are driving traffic to your site.
  5. The Tech Page, will help you optimize your site to the technology your audience uses. and finally,
  6. The Demographic Page, will help you learn more about your audience.

How to get data into Power BI

  1. Create account at windsor.ai
  2. Connect to GA4
  3. Get API key
  4. Parameters
  5. User Page
  6. Acquisition Page
  7. Content Page
  8. Site Speed Page
  9. Site Search Page
  10. Lead generation Page
  11. Feedback
  12. Release Notes

Create a Windsor.ai account

Go to windsor.ai and select a tier:
1. Free tier
2. Paid tier (use my discount code: CURBAL for 15% off)

And connect your GA4 account:

  1. Search for google analytics 4
  2. Select the account you want to connect to
  3. Sign in with your google account
  4. Click next

Get your API Key

Click on Power BI desktop:

and then click on APIKEY to copy the key. You will need it later.

Connect your data with the App

Open the downloaded file and fill in the following parameters:

  1. DateFormat: Here you can specify the regional settings, so the date will be in your local format all codes here. ex. sv-SE
  2. Language: Here you can specify the regional settings, so the Month Name and the Day Name will be in your local language. You can find all language codes here.
  3. StartWeekDay: Does the week start by Sunday or Monday? Use 1 for Sundays and 2 for Mondays.
  4. ApiKey: Enter the key you got in the previous step.
  5. Days to load from yesterday: Pick an option in the drop down menu.
  6. Domain: Here you specify the domain of your website. For example, if the URL for your website is: www. curbal-blog.se, then the name to enter here is: se (without the dot).
    Note: This is used to create a link to the pages on your site, if you enter this wrong, you wont be able to navigate to your pages.

And if you entered of all the parameters successfully, the app will be generated with your data.

Purchase the template app

If you tested the app and you want to personalize it, you can buy the report here:

  • Google analytics 4 template for Power BI
    Google Analytics 4 Template App by Curbal
    449 € (Price excl. VAT: 359 €)
    Add to cart

Filed Under: Google Analytics

Join our community of over 50,000 professionals

Become a Member

Subscribe to YouTube

Reader Interactions

Comments

  1. David

    January 26, 2017 at 1:38 pm

    Hey guys
    It is possible to get the E-commerce data from analytics to power bi. I can´t find a way to get this data. There are only the traffic data.

    Reply
    • Ruth Pozuelo Martinez

      January 26, 2017 at 6:33 pm

      Hi David,

      It is possible to get e-commerce data, just pick the fields you would like from the e-commerce folder:
      https://curbal.com/2017-01-26_17-05-12

      If there is data in google analytics, power bi will pick it up!
      /Ruth

      Reply
  2. Adi

    December 3, 2015 at 3:41 pm

    Is there a way to also export Google AdWords data to Microsoft Power BI

    Reply
    • Ruth Pozuelo Martinez

      December 3, 2015 at 5:20 pm

      Hi Adi,

      No and yes.

      No, there is no connector available (at least yet) in Power BI and yes, if you link your Google Analytics account with your AdWords account:
      http://curbal.com/blog/link-adwords-with-google-analytics
      you can export that data to power BI.

      I am planning a post on Adwords and Power BI, stay tunned!
      /Ruth

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In