Google Analytics GA4 Connector Fails to connect

[miquelmartorell]

Google Analytics GA4 Connector 2.0 (beta) fails to connect in April 2024 version 2.128.1380.0 Power BI Desktop.

"Details: "The 'accounts' field of the registry was not found"."

Here is the error:

[CoderZen08]

Hi @miquelmartorell Were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supermetrics 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. 

[miquelmartorell]

Good morning @CoderZen08

Native connector GA4 works fine 😉

Thank you.

[Anonymous · Accepted solution]

Hi,@miquelmartorell 

Regarding the issue you raised, my solution is as follows:

My solution to the issue you have raised is as follows:

1.Based on the error message you provided, it is likely that there is an authentication issue, so try checking the connector configuration: Make sure that the Google Analytics GA4 connector is properly configured in Power BI.

You can click "editar" in the error message you provided to verify that you correctly specified all required fields when establishing the connection, especially the "Account" field in the error message you provided.

2.you can also try returning to an older version of GA if the issue is still not resolved. To the best of my knowledge, Google Analytics has two V4 APIs: V4 Reporting and V4 Data.Power BI does not currently support GA4 Data, but does support GA4 Reporting. Please confirm that it will meet your needs after using this approach.

3.Below is the relevant documentation:

Power Query Google Analytics connector - Power Query | Microsoft Learn

Set up your Google Analytics connection - Microsoft Fabric | Microsoft Learn

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.