How to Connect Google Analytics to Microsoft Power BI

When it comes to being a business in 2021, your company’s website is a must-have. A website is key for ensuring your customers are able to find information about your product or service as well as a way to contact you.

With this resource, many website owners are interested in understanding the metrics and analytics for their websites. They are looking to answer important questions such as how many users are visiting my website or how our users are finding my website? The industry standard and best tool for this is Google Analytics.

Google Analytics is a very expansive tool with built-in reporting. If you are looking to answer unique questions, create custom calculations, or combine this data with another source, you may want to use a tool like Power BI to visualize and measure your website and Goals performance.

In this blog, we will review how to connect Google Analytics to Power BI so that you can model and visualize your website data. The great news is this is a fairly simple process as Power BI has a third-party Google Analytics connector.

Sections:

What is Google Analytics?

Google Analytics is a powerful tool that tracks website usage and tracks for free. In order to utilize the tool, you must have an account and add the tracking code to your website. Learn how to do this in this tutorial here.

Some use cases for Google Analytics include measuring website traffic, measuring social media pages, measuring Eventbrite pages, and more.

What is Power BI?

Power BI is the leading business intelligence tool from Microsoft. It is used to connect data sources to model and visualize data into a report-ready format.

The ability to gather data from different sources into one is the main benefit of utilizing Power BI and Google Analytics together.

Step 1 – Click on “Get Data”

If you do not have Power BI downloaded then you can go to https://powerbi.microsoft.com/en-ca/downloads/

or get it through the Microsoft Store on a Windows computer.

Once you have Power BI open, in the ribbon near the top left of the screen you should see a button called Get Data.

Figure 1- Power BI File

Figure 2 Get Data Button

Click on Get Data and select the More option.

Figure 3 Select More from the Get Data menu

In the Get Data dialogue box, scroll down to find or search for the Google Analytics connector.

Figure 4 Select the Google Analytics Connector

Power BI will then notify you that the Google Analytics connector relies on a 3rd party service. You can just select Continue to move past this dialogue box.

Figure 5 Notification of Third-Party Service

Step 2 – Sign in to Google Analytics and allow Power BI access

Power BI will now prompt you to sign in to your Google Analytics account.

Figure 6 Sign in to your Google Analytics account

Select the account that is attached to the Google Analytics account that has the data you wish to access.

Figure 7 Select your Google account

You then must allow Power BI to access your Google Account.

Figure 8 Allow Analytics Access

Once you have allowed access, return to your Power BI file and you will see that you are now signed in. Click Connect to continue.

Figure 9 Logged In

Step 3 – Load Google Analytics Data into Power BI

Connecting will open the Navigator box. This is where you will select which data you would like to be loaded into Power BI. The options are set up the same way that the Google Analytics account hierarchy is set up.

The top-level is the Account, the second level is the Property, and the bottom level is the View. Select which account, property, and view that contains the data you are looking for.

Figure 10 Navigator Box

In order to load in the data, you must ensure that you have the proper permissions in Google Analytics. The last step is to select the tables and load the data.

Figure 11 Select Data to Load

Here you have two choices. If you select Load, the data will come into Power BI and the dialogue box will close. If you choose Transform Data, this will load the data into Power BI and open the Power Query Editor so that you may transform and clean the data as necessary.

If you are new to Power BI and are wanting to learn how to transform your data, check out our Introduction to Power BI 2-day training. This is an instructor-led course that will get you on the right track with Power BI.

Where to start with visualizing Google Analytics Data

After connecting the data, the next part is to build a dashboard that will display our insights.

If you are new to Power BI and not sure where to start with building visualizations check out the Power BI AppStore.

Here you will find templated dashboards for you to populate with your data. Note that you may need to pay to use some of these templates.

Conclusion

There you have it! You have now successfully connected your Google Analytics data to Power BI. From here you can now create your calculations and measure to answer your website analytics questions.

Next, you can build a beautiful dashboard with visualizations that present the information you want at your fingertips.

Share This

Share on linkedin
Share on twitter
Share on facebook
Share on email

Leave a Reply

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

Latest Posts

Creating a Simple Naive Bayes Predictive Model in Power BI

Stephen Zielke PhD

Sensitivity Labels in Power BI

Diana Arciniega

10 Data Analytics Courses to Expand your Career in Ontario

Joelle Mason

How to Connect Google Analytics to Microsoft Power BI

Renata Kalsbeek

All Aboard, the Power BI Premium Gen2 Train!

Tutu Hamid

Are you eligible for the Canada Alberta Job Grant?

Renata Kalsbeek

Hot Topics

Stay Up to Date with Our Latest Blogs

Subscribe to our mailing list to be notified when a new blog is released.

Let's get started with a consultation

get started with training