Export Google Analytics data to Microsoft Power BI

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: