Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

power query data issue

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

 

Need Help

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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