GA connector in Power BI (after upgrade to GA 4)

[SisterRay]

Hello everyone,

The client use Google Analytics 4, and when I try to use the GA connector in Power BI, sites are not showing in the list of websites. It seems to affect sites that don't have a UA number in Google Analytics. There is one account with several Properties&Apps  without UA. When I get data in Power BI I get "The key didn't match any rows in the table" error.

I haven't been able to find anything via Google. Has anyone had a similar issue and worked out how to solve it?

Earlier we've used script below before upgrade to GA 4 (result was ok):


let
Source = GoogleAnalytics.Accounts(),
#"<ID>" = Source{[Id="<ID>"]}[Data],
#"UA-<ID>-1" = #"<ID>"{[Id="UA-<ID>-1"]}[Data],
#"<View ID>" = #"UA-<ID>-1"{[Id="<View ID>"]}[Data],
#"Added Items" = Cube.Transform(#"<View ID>",
{
{Cube.AddAndExpandDimensionColumn, "ga:source", {"ga:source"}, {"Source"}},
{Cube.AddMeasureColumn, "Users", "ga:users"}
})
in
#"Added Items"

Many thanks in advance!

[ReportBuilder07]

Hi, now you have the 2.0 beta connector which is compatible with GA4 data but that one still have some issues sometimes with the data. As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics 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. 

[sambo345]

Hi if you're still looking for a solution this migth help: https://cooriedug.com/custom-ga4-power-bi-connector-setup/

[Hcfoo]

I'm having the same issue here. Google just announced they will sunset Universal Analytics (UA) in 2023. We hope The Power BI team at Microsoft will look into the solution soon. 

[v-easonf-msft · Accepted solution]

Hi, @SisterRay 

This may be a compatibility issue, you may need to contact the Microsoft Support Team to confirm this incident.

The Google Analytics connector in Power BI Desktop relies on the Google Analytics Core Reporting API. As such, features and availability may vary over time. Although the development team attempts to release updates in accordance with any changes, the API may change in a way that affects the results of the queries . In some cases, certain queries may no longer be supported. Due to this dependency, the results of your queries are not guaranteed when using this connector.

You can refer to this document about the Limitations and issues.

Best Regards,
Community Support Team _ Eason