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.
Hi pawankarki23,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
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.
I tried to set up a BigQuery connector in the meantime while the Google Analytics to Power BI Connection was not working for the Scheduled refresh and I got to a certain point and it was failing to connect to the BigQuery project I had set up.
SQL Statement I am trying to use:
SELECT
PARSE_DATE('%Y%m%d', event_date) AS date,
user_pseudo_id,
device.category AS device_category,
device.web_info.browser,
device.operating_system,
geo.city,
geo.country,
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = "page_title") AS page_title,
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = "content_group") AS page_category,
engagement_time_msec
FROM
`cogent-node-459214-r4.analytics_320122991.events_*`
WHERE
_TABLE_SUFFIX BETWEEN '20250101' AND '20250516'
AND event_name IN ('page_view', 'user_engagement');Is there something wrong with the SQL Query I am using here as it keeps failing. I am trying to find out how can Query the BigQuery project I have created based on the GA4 Data I have.
