Forum Discussion
PowerBI Service Scheduled refresh error for Google Analytics
Hi all, this has been resolved by devs it seems. I went to check if I could put my report back on scheduled refresh just there and it is now working again. So, the token issue that I am assuming was preventing the connection from Google Analytics to Power BI is now working fine.
Based on the consistent error message of "unexpected character in the JSON input" and the fact that multiple users have reported this, the root cause is very likely a change or regression in how the Power BI Service handles the OAuth token response from the Google Analytics connector v2.
More specifically the Power BI Service backend is failing to parse a part of the OAuth 2.0 response JSON but this does not affect Power BI Desktop, as the OAuth flow there is handled differently (locally).
Roight now you can use BigQuery as an Intermediary if your organization has access to BigQuery (especially if you’re using GA4). Export your Google Analytics data to BigQuery (this is supported natively in GA4). Then in Power BI Service, connect to BigQuery using the BigQuery connector (OAuth works fine here). Now schedule refresh using that source.
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
Best Regards,
Hammad.
Community Support Team
I have same issue that popped up maybe 1 month ago? (Used to work before that...)
And it kinda affects my entire workspace of external dashboards for clients >100 🙂
I appreciate the workaround, but shouldn't a connector provided by MSFT also be usable for PowerBI Service ideally? And why do we have to submit a ticket when it is clear that this is a recurring problem/bug based on the answers here. Or is it implied that developers and PM don't read these forums and only will move for a fix if somebody submits a ticket?
Hi Lawliim,
Thank you for your response. As this forum is an open platform for all users to raise their queries and share their problems/issues related to PowerBi and Microsoft Fabric, sometimes there are issues which are escalated to Microsoft Support teams where they extensively work on the issue and try to solve it.
Best Regards,
Hammad.