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?
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.
Here is a duscussion that GA4 connector is planned for release at the end of 2023. Meanwhile you may try to import GA4 data into windsor.ai account and access your GA4 data from Power BI.
Good morning, we are with the same inconvenience, we need the GA4 connector for our customers!
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.
Hi if you're still looking for a solution this migth be of help - https://cooriedug.com/custom-ga4-power-bi-connector-setup/
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:
Link to blog about connecting GA4 to Power BI
(It's in dutch, so you might need to use Google Translate)
This is still an issue - can someone please show me how you set it up with BigQuery?
Yes, this is a big issue!
I would also like an update. Hopefully this comment "bumps" this thread
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:
thannks a lot
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.
😄 hehe wow. The world continious to spin around microsoft as well.
Thanks and I appreciate any progress 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.
I dont want to push it but is there really no one here who can comment 🙂 ?
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.