Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
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!
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.
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
Can you show me how to replace the values in Power Query please?
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 41 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 69 | |
| 32 | |
| 27 | |
| 26 |