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...
Need Help
Tips and Tricks
powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago

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's avatar
    Anonymous
    Not applicable
    1 year ago

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