Forum Discussion
Error when trying to get data from GA for City
Hello
When I try to get data from Google Analytics to Power BI for the "city" data, I keep getting an error in the last column saying there is unexpected character in the JSON input with the last column in my data being filled with "Error"
I've tried the "remove error" option under the "remove rows" section , but it does not seem to get rid of the issue and I keep getting the following below
We found an unexpected character in the JSON input.
Details:
Value=\31
Position=0
This only occurs with the City data. I have tried to pull small data with only a couple days worth of data and limited pages but still fall into the same issue.
Any help would be appreciated!
4 Replies
- powerbiexpert22
Impactful Individual
Hi Anonymous .
you can try to use replace values in Power Query or you will have to clean data in GA before loading in Power BI
- AnonymousNot applicable
Can you show me how to replace the values in Power Query please?
- AnonymousNot applicable
Hi Anonymous
You can try the method provided in the fourth reply in this post, hope it will help you.
Problem with GA4 2.0 connection - Microsoft Fabric CommunityBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.