• Skip to main content
  • Skip to footer

Curbal

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

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / Google Analytics / Export Google Analytics data to Microsoft Power BI (supercharged Excel)
Export Google Analytics data to Microsoft Power BI (supercharged Excel)

Export Google Analytics data to Microsoft Power BI (supercharged Excel)

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 and on future posts we will create useful reports with the data and Power BI.

A few words about Power BI

Before we start, and in an attempt to avoid confusion later on, there are more than one Power BI out there and you need to know which one to choose:

  1. Power BI web: This is the web version of Power Bi (www.powerbi.com)
  2. Power BI Desktop: This is the software we will use here (a standalone free version of Power BI)
  3. Power BI Office 365: This version is an add-on for your office 365 license
  4. Excel: yes, excel has all the Power BI functionality but they call it: Power View, Powerpivot, Power Query.

You probably wonder why I would use Power BI Desktop and not Excel, and the answer is simple: You need a 64-bits computer if you dont want Excel to crash all the time and Excel does not have the Google Analytics connector we will use in this tutorial. I am guessing that the reason they don’t have it is to get people to use Power BI Desktop and Web. Fair enough.

Watch it on YouTube

If you prefer, you can watch our demo in YouTube, otherwise you can follow a step by step guide below. Let’s start.

How to export data to google analytics Youtube

Download Power BI Desktop

To download the power BI software, simply navigate to the Power BI site and click on download.

A word of caution! If you don’t want Power BI in your own language, click on “Advance download options” to select the language first.

0 download power bi

Follow the installation instructions and when ready open Power BI and click on “Get Data”:

GetData power bi

Now, lets look for the Power BI connector: Search for Google Analytics:

get data google analytics

Accept the terms and conditions and click ” Continue”:

3 connecting to 3rd party power bi

Now you will be asked to Sign in to your Google analytics account:

4 signin google power bi

Sign in your Google Account:

5 enter your email

and allow the Power BI tool to access your Google Analytics data:

6 give power bi access

If everything goes well Power BI will connect to your Google Analytics account:

7 connect to google

Immediately after you connect, you will be presented with all your accounts(1), properties(2) and views(3) and you will see all available categories (4) and dimensions(5) and metrics:

8 Select account and properties

Creating our first report

Now that we are in, lets create a simple report to demonstrate how to use the tool.

Let’s select the following dimensions/ metrics from the following categories:

  • From Time: Year
  • From User:Users and
  • from Session: Sessions

Microsoft has design this connector very well, you will get a Data Preview as you select your metrics and dimensions.

Once you are happy with your selections, click on “Load”.

9 simple session report

And all your data will be loaded to your Report canvas.

10 data fields power bi

Lets create a graph of data. Click on the boxes and the data will be presented as a table in your canvas:

11 data to table

To create a line graph, simply click on the line graph visualization icon:

12 change to Line chart

And you have created your first chart outside Google Analytics.

Now the all the data is available to you to create the best fitting reports for your business or website.

Next Post:

Would you like to know how much your site is growing in one click? Re-create or download our Growth Dashboard.

Growth Dashboard power bi google analytics

Need ideas for new posts or content on your site? Re-create or download our Ideas  Dashboard.

New ideas dashboard power bi google analytics3

 

 

 

Filed Under: Google Analytics

Join our community of over 20,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

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

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