Forum Discussion
Google Analytics Connector Schedule Refresh Problem in Power BI Cloud
Hi HoFa ,
It looks like the issue with the Power BI Cloud Connector for Google Analytics stems from changes or instability in the Google Analytics 2.0 (Beta) API, which may be returning malformed or unexpected JSON responses during scheduled refresh attempts. The error “We found an unexpected character in the JSON input” usually indicates that Power BI is unable to parse the data being returned—possibly due to formatting issues, an expired or invalid token, or recent changes in the API's structure. Since manual refresh still works, it confirms that the credentials are likely valid but the cloud service is struggling to interpret or handle the data when automating the process.Your workaround using the On-premises Gateway with the "Skip test connection" option is a valid interim solution and suggests the cloud environment may have stricter validation or less tolerance for minor API inconsistencies. To move toward a permanent fix, consider filing a support ticket with Microsoft, referencing the JSON parsing issue and the error received when attempting to create a new Cloud Connector. Additionally, it may be worth checking if there are any updates or changes announced by Google regarding the GA 2.0 Beta API that could be impacting third-party connectors.
Hi HoFa,
Thank oyu Akash_Varuna for your input to the issue.
Based on the consistent error message "unexpected character in the JSON input" and reports from multiple users, it’s highly likely that the root cause is a regression or change in how Power BI Service handles the OAuth 2.0 token response from the Google Analytics connector v2 (Beta). Specifically, the Power BI Service backend appears to be failing to parse a part of the JSON response, leading to the refresh error. This issue does not affect Power BI Desktop, where the OAuth flow is processed locally and works as expected.
Right now, a reliable workaround is to use Google BigQuery as an intermediary, especially for those using Google Analytics 4 (GA4). GA4 natively supports exporting data to BigQuery. Once the data is in BigQuery, you can connect to it from Power BI using the BigQuery connector, which handles OAuth properly in the Power BI Service. You can then set up scheduled refreshes using the BigQuery connection, which avoids the issue entirely.
If you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with Microsoft Support.
Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
I hope this helped! Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.
Thank you.