Error when trying to get data from GA for City

[Anonymous]

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!

[Anonymous]

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 Community

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbiexpert22]

Hi @Anonymous ,

https://support.microsoft.com/en-us/office/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721

https://www.youtube.com/watch?v=XpZTPEBHQOY&pp=ygUZcmVwbGFjZSB2YWx1ZSBwb3dlciBxdWVyeQ%3D%3D

[powerbiexpert22]

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

[Anonymous]

 Can you show me how to replace the values in Power Query please?