Random Characters in Text Column

[naufal_msr]

Hi guys,

I'm loading a dataset from Google Big Query. The data looks fine in Big Query however upon loading in PBI, there are random characters generated across the column. It looks something like this : 

{"v":{"f":[{"v":"BU2"},{"v":"Outlet"},{"v":"1526"}]}}

{"v":{"f":[{"v":"BIP"},{"v":"Outlet"},{"v":"4515"}]}}

{"v":{"f":[{"v":"EMP"},{"v":"Outlet"},{"v":"1649"}]}}

The supposed value for first column is BU2, BIP and EMP, while the Outlet and Numbers are on different columns. I only have issue with this column. Any idea what is causing this random characters to appear ?

Thank you.

[Anonymous]

Hello @naufal_msr,

I had the same issue when connecting Power Query to Big Query.

To solve this problem, you need to do a SQL query on the connection advanced tab.

This worked for me.

Cheers,

Hugo

My Linkedin 

[Anonymous · Accepted solution]

Hi @naufal_msr 

This may be caused by the data structure in Google Big Query. If all values are in this format, you can try to transform your data in Power Query Editor by Split function. 

Here I split column by positions.

Then remove the columns we don't need. Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.