Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
arshiagov23
New Member

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

arshiagov23_0-1733439225394.png

 

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 4
Anonymous
Not applicable

Hi @arshiagov23 

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

vjialongymsft_0-1733453033166.png

 

 

 

 

 

 

 

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
Impactful Individual
Impactful Individual

Hi @arshiagov23 .

you can try to use replace values in Power Query or you will have to clean data in GA before loading in Power BI

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors