Google Analytics connector - error after signing in with GA4 credentials

[aohara15]

We are receiving this error reconfirming our credentials to our Google Analytics account. We haven't changed a single thing on the report in months and are just now receiving this error so it seems this is an issue on google's end. 

I found similar posts with this same issue (https://community.fabric.microsoft.com/t5/Power-Query/quot-We-found-an-unexpected-character-in-the-J...).

Has anyone found a fix?

[v-csrikanth]

Hi @aohara15 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @aohara15 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @aohara15 

It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth · Accepted solution]

Hi @aohara15 
A practical workaround for the GA4 connector issue is to export your GA4 data to Google BigQuery and then connect Power BI to BigQuery. This approach gives you more flexibility, control, and reliability when reporting on GA4 data.

Export GA4 data to BigQuery
Export Google Analytics 4 data to BigQuery

Connect Power BI to BigQuery
https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery 

This method avoids the instability of the GA4 connector and allows you to work with full GA4 datasets in Power BI.

Hope this helps.

If this resolves your issue, please consider marking it as the accepted solution to assist others in the community.

Best regards,
Srikanth
Power BI & Fabric Community Support Team

[v-csrikanth]

Hi @aohara15 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @aohara15  
Please check the following troubleshooting steps that might resolve your issue.

• Ensure you’re using the latest version of Power BI Desktop and the Google Analytics connector, as Microsoft has released updates to improve GA4 support.

• If using a service account, make sure the JSON key file is original and unmodified5.

• If using OAuth2, try removing and re-adding the connection.

• Double-check that you’re selecting the correct authentication method and that your Google Analytics account has the right permissions.

• Few users have had success by limiting the amount of data requested per query.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[aohara15]

Hi there - I have tried and checked all of these ideas that you have listed and am still receiving the same error.