Forum Discussion

PC2790's avatar
PC2790
Community Champion
5 years ago
Solved

JSON data from Google Big Query not interpreted correctly once extracted in Power BI

Hello guys,

 

So I am working on this piece of work where I am trying to fetch Google Big Query data in Power BI, however when I do that in normal tabular format, it comes out to be somewhat gibberish.

Something like below:

This is useless to me as I cannot use thi sdata as required.

I stumbled upon a similar post -https://community.powerbi.com/t5/Desktop/How-to-resolve-Nested-Big-Query-Data/td-p/1327846 and can see that it is marked as an Solved, however I am not able to figure out how.

 

Can anyone please advise how this can be approached please?

P.S- As the data is sensitive, I won't be able to share the data. If there is any other wa, please donot hesitate to suggest.

 

Thankyou in advance

Need Help

3 Replies

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    Hi PC2790 

    Please check whether there are other tables in the Navigator Pane. Maybe some tables contains proper data.

     

     

    Best Regards

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution . Really appreciate!

     

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    So when I try to download the data in the offline mode as JSON format and the load in Power BI as JSON, it works fine.

    So what I am not doing is UNNESTING the data as:

     

    Select *, co.value
    from <table> as tablename,
    UNNEST(NestedColumnname) as co
     
    I am looking for ways to get this query saved as view so that I can consume it in Power BI