Forum Discussion

NOG's avatar
NOG
Frequent Visitor
8 years ago

connecting to nested data in Big Query

Hi I can get data out of Big Query without a problem if it comes from Goggla Analytics and is related to web but doing the same when the data comes from an App via Firebase makes it ...strange when ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi NOG,

 

Can you please store your data into txt file and upload onedrive/google drive, then share the link here.

It is hard to analysis your data from snapshot.

 

Regards,

Xiaoxin Sheng

NOG's avatar
NOG
Frequent Visitor
8 years ago

Hi

Here is part one sample f the nested data that I get from Big Query

This is data about one specific event

And I want to be able to use this data in PBI

txt file

//NOG

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi NOG,

     

    I try to analyse your sample and expand nested records, you can take a look at below sample file.

     

    Notice: it seems like only 12 rows available in your sample, row 13 is missing characters so I remove it.

     

    Regards,

    Xiaoxin Sheng

    • p_peredriy's avatar
      p_peredriy
      New Member
      6 years ago

      How can I split a row into columns + delete {"v": {"f": [{? Faced the same problem

  • ElliotP's avatar
    ElliotP
    Post Prodigy
    8 years ago

    Hi,

     

    That looks like it might be json. This thread might be helpful for un-nesting, it provides a few means.