Google Analytics 4 is coming and I am wondering if the native Power BI Connector can be used to pull Data from the Google API. I already have some accounts in place but cant see the properties in power bi. So I am wondering if this feature is supported or not.
Any comments on that?
Update (August 2023):
The Google Analytics connector in PowerBI now supports GA4 using the "Implementation 2.0".
Everyone using the earlier version might need to update their connection to use implementation 2.0.
See the link to the update:
Good morning everyone - I wanted to bump this thread again to see if there were any in-built solutions for GA4 connections within PowerBI that do not require daily manual updating of code or additional budget for things like BigQuery? This should be a standard connector given how many of my clients alone are migrating to GA4 in the next 2-3 months alone.
Appreciate any guidance! My org cant be the only one trying to navigate this.
Yes, it is possible to pull data from Google Analytics 4 into Power BI using the native Google Analytics connector. However, as of now, the native connector in Power BI only supports Google Analytics Universal Analytics (UA) version and does not support Google Analytics 4 (GA4) version.
To pull data from GA4 into Power BI, you can use a third-party connector like the "Google Analytics Pro" connector developed by CData Software. This connector allows you to extract data from GA4 using its API and import it into Power BI.
Alternatively, you can also export data from GA4 as a CSV file and then import it into Power BI using the "Get Data" feature in Power BI. However, this method may not be feasible if you require real-time data or have a large amount of data.
Overall, while the native Power BI connector does not currently support GA4, there are other options available for importing GA4 data into Power BI.
I wrote this blog on my website that is very helpful to answer this question!
This blog explains all the ways of how Google Analytics 4 data can be connected to Power BI:
(It's in dutch, so you might need to use Google Translate)
Here also waiting... I manage to connect but it appears blank.
I followed the indications marked above but
1/ With the first link: for the GA4-BigQuery connection to work it is necessary that the account has billing enabled, so right now it is not an option. I've managed to access one-day data... you should repeat the process every day to do so (not an option).
2/ With the second link it asks me for a viewID and with GA4 it does not exist.
The old link was ideal...
I tell you that today I was talking to people from Microsoft support and they had no idea what I was talking about. In other words, I didn't even know that Google Analytics 4 existed. For them at the moment there is only the connector to the standard GA and they do not know when the new connection is going to be generated.
They told me they were going to find out and contacted me again.
So for the moment the only thing left to test is either use the old GA or try migrating the data to the Google Data and there make the connection. This I still did not prove, because I wanted to confirm to see if there was something simpler.
Well, any novelty I upload.
Good point, but for e.g. you want to set up a new property within GA there is no other possibility anymore to go for UA. You have to join GA 4 but this does not give you a connector for PowerBi.
Pretty **bleep**t i have to say.
Hi @_boerndt_ , it is still possible to set up UA properties actually. You need to click on 'Show advanced options' in the property setup wizard:
True. I am following a different approach now. I directly get the data from google and store them in a seperate database. Having the connector in PBI would however be ever convenient especially for quick reports or analysis.
I hope the MS Team will follow up on that.
Please refer the following about connect Google Analytics 4 with BigQuery, and then you can push data to Power BI.
If you still have some question, please don't hesitate to let me known.
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Thank you @v-xulin-mstf ,
I understand - thank you for those resources!
Means that one would need a BigQuery Instance. This makes it a little accessible than before. A bummer as it was very handy before to just jump into analytics without having to setup anything.
Especially in an enterprise environment this creates a couple of hurdles as many other stakeholder need to be involved.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.