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
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