"We found an unexpected character in the JSON input" error in getting data from google analytics

[oiluj0002]

I need help!

When I need to import some Data from google analytics API in Power BI I get that error and can't import data anymore at least for hours. It is related to the data inside GA4 or another thing?

[Syndicate_Admin]

Hello, did you find some workaround for this issue? Thank you

[oiluj0002]

Not exactly. Magically the GA4 api worked, i think it's a problem with connection between GA4 and PowerBI

[MongooseGeneral]

I've been getting this too to the point where I can't refresh the data anymore so must be an issue with the connector / PowerBI. I meant to post about it but was hoping it would resolve itself.

It seems like it can process a certain amount but then I get the error and from then on it just fails instantly for all GA4 sources for a period. Glad to know it's not just me.

I do have GA4 data in other reports that is refreshing OK, so I wonder if it's due to the amount going through. I might try heavily filtering the data once it lets me to see if that helps. I've been having the problem for at least 2 weeks, probably longer I think.

Hopefully someone else knows more.