Forum Discussion
Random Characters in Text Column
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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