Connecting to Google Analytics 4

[Syndicate_Admin]

Hi,

I am trying to connect to Google analytics from my PowerBI desktop but after selecting the beta version i get the following error

Any solutions to this?

[Syndicate_Admin]

It might be you are trying to connect accounts field from GA4 but the field “accounts” isn’t in your GA4. Here are a few approaches you could try to resolve the issue.

• Make sure the accounts field is in your GA4.
• Power BI desktop is updated (July 2023 or after).
• Clear all permission of Google Analytics connection and retry to connect.
• Or create a new power BI file and try to connect again with proper information.

If you want to know the GA4 connection with Power BI, check out this documentation.

Did my answer help you or lead you to a solution? If so, please consider marking my response as a solution and giving kudos 👍

Thank you!

[Syndicate_Admin]

It might be you are trying to connect the accounts field from GA4 but the field “accounts” isn’t in your GA4. Here are a few approaches you could try to resolve the issue.

• Make sure the accounts field is in your GA4.
• Power BI desktop is updated (July 2023 or after).
• Clear all permission of Google Analytics connection and retry to connect.
• Or create a new power BI file and try to connect again with proper information.

If you would like to know the GA4 connection with Power BI, check out this documentation.

Did my answer help you or lead you to a solution? If so, please consider marking my response as a solution and giving kudos 👍

Thank you!

[Syndicate_Admin]

It might be you are trying to connect the accounts field from GA4 but the field “accounts” isn’t in your GA4. Here are a few approaches you could try to resolve the issue.

• Make sure the accounts field is in your GA4.
• Power BI desktop is updated (July 2023 or after).
• Clear all permission of Google Analytics connection and retry to connect.
• Or create a new power BI file and try to connect again with proper information.

If you want to know the GA4 connection with Power BI, check out this documentation.

Did my answer help you or lead you to a solution? If so, please consider marking my response as a solution and giving kudos 👍

Thank you!

[Syndicate_Admin]

It might be you are trying to connect accounts field from GA4 but the field “accounts” isn’t in your GA4. Here are a few approaches you could try to resolve the issue.

• Make sure the accounts field is in your GA4.
• Power BI desktop is updated (July 2023 or after).
• Clear all permission of Google Analytics connection and retry to connect.
• Or create a new power BI file and try to connect again with proper information.

If you like to know the GA4 connection with power bi, check out this documentation.

Did my answer help you or lead you to a solution? If so, please consider marking my response as a solution and giving kudos 👍

Thank you!

[Syndicate_Admin]

Hi @opta13stats 

The error message displays that the account is not found in the data source, please check that is the field is existed in your data source, then you can try to clear the data source permission from the Power BI Desktop, then connect the data source again, you can remove the permission from the settings in Power BI Desktop.' File->Options and Settings->Data source settings" then remove the permission.

Best Regards!

Yolo Zhu

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

[Syndicate_Admin]

Hi @opta13stats In case this happens to you again, 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.