power query data issue

[nsatyabrat7]

Hi,

   I am reading data from google big query through power bi connector. My data in bigquery is like this for platform column.

  Platform    

   web

   android

   ios 

But power query is returning like following

{"v":{"f":[{"v":"ios"},{"v":"ios"},{"v":"app"}]}}
{"v":{"f":[{"v":"web"},{"v":"web"},{"v":"web"}]}}

Need help.

Thanks

[Anonymous]

Hello @nsatyabrat7 ,

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 

[Mariusz · Accepted solution]

Hi @nsatyabrat7 

Try the solution on the attached.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Mariusz]

Hi @nsatyabrat7 

Is it like a column with 2 rows?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn