Google Analytics Connector (GA4)

[Syk]

Has there been any word about when a connector to Google Analytics 4 will be available? With Google Analytics UA sunsetting in 2023, there is not a good way to switch between the two. Other posts (see linked below) here have left me wondering if MS intends to do any integration with the next version of GA as the current method is to use a BigQuery instance to pull data from GA4 then into Power BI.

Power BI Google Analytics 4 Connector - Microsoft Power BI Community
GA4 Connector - Microsoft Power BI Community

[v-cazheng-msft]

Hi @Syk,

Currently, Google Analytics connector is using V4 of Google Analytics API, and it only provide programmatic methods to access report data in Google Analytics (Universal Analytics properties only).

https://developers.google.com/analytics/devguides/reporting/core/v4/

For the need of the improvement of Google Analytics connector, you need to vote for similar idea in Power BI Ideas. It’s a place where  the product group collects suggestions from users to improve this product.

https://ideas.powerbi.com/ideas/search-ideas/?q=Google%20Analytics%20Connector%20(GA4)

To learn about the roadmap of Power BI, you could access these official sites.

Product Roadmaps | Microsoft Dynamics 365

Release planner (PREVIEW) (dynamics.com)

Best Regards,

Community Support Team _ Caiyun

[GavinBrogan]

As previous answers point out V4 API is actually for UA. If you need GA4 the you need the Google Analytics Data API v1. At time moment there isn't an official GA4 connector so options are limited however, I have put together a custom connector which you are welcome to give a try until something official comes along. 

I've written a blog article on setting it up. takes about 20mins. 

https://cooriedug.com/ga4-power-bi-connector-beta/

[ReportBuilder07]

Hi @Syk Beta 2.0 connector is available and seems to be compatible with GA4 data, however I've used it and I had some issues with my data sometimes. As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url