Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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