The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 @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
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 @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?