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:
- The User Acquisition Page, will allow you to get a deeper understanding on how your new users reach your site.
- The Traffic Acquisition Page, will help you understand where your traffic comes from for new and return users.
- The Pages page, lets you analyze your content so you can improve it or create more of what is working already.
- The Landing Page , will help you understand which pages are driving traffic to your site.
- The Tech Page, will help you optimize your site to the technology your audience uses. and finally,
- The Demographic Page, will help you learn more about your audience.
How to get data into Power BI
- Create account at windsor.ai
- Connect to GA4
- Get API key
- Parameters
- User Page
- Acquisition Page
- Content Page
- Site Speed Page
- Site Search Page
- Lead generation Page
- Feedback
- 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:
- Search for google analytics 4
- Select the account you want to connect to
- Sign in with your google account
- 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:
- DateFormat: Here you can specify the regional settings, so the date will be in your local format all codes here. ex. sv-SE
- 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.
- StartWeekDay: Does the week start by Sunday or Monday? Use 1 for Sundays and 2 for Mondays.
- ApiKey: Enter the key you got in the previous step.
- Days to load from yesterday: Pick an option in the drop down menu.
- 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 App by Curbal449 € (Price excl. VAT: 359 €)
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.
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
Is there a way to also export Google AdWords data to Microsoft Power BI
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