Power BI Google Analytics 4 Connector

[raymondpocher]

Hello Community,

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?

[mrnelsch]

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:

https://tada-solutions.nl/google-analytics-4-koppelen-met-power-bi/

(It's in dutch, so you might need to use Google Translate)

[ALCR22]

This is still an issue - can someone please show me how you set it up with BigQuery?

[felixnicol]

Yes, this is a big issue!

[TrevLc]

I would also like an update. Hopefully this comment "bumps" this thread

[Syndicate_Admin]

Good!

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...

[Syndicate_Admin]

Hello everyone.
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.

Best regards

[_boerndt_]

Hey @Syndicate_Admin 
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.

[adamrobc1]

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:

[_boerndt_]

thannks a lot

[raymondpocher]

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. 

[raymondpocher]

😄 hehe wow. The world continious to spin around microsoft as well.

Thanks and I appreciate any progress on that

[v-xulin-mstf]

Hi @raymondpocher

Please refer the following about connect Google Analytics 4 with BigQuery, and then you can push data to Power BI.

https://www.optimizesmart.com/how-to-connect-google-analytics-4-with-bigquery/

https://www.optimizesmart.com/visualizing-google-analytics-data-via-microsoft-power-bi/

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[raymondpocher]

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. 

[raymondpocher]

I dont want to push it but is there really no one here who can comment 🙂 ?