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 provide more detail information to help us clarify your requirement?

 

Regards,

Xiaoxin Sheng

NOG's avatar
NOG
Frequent Visitor
8 years ago

Below is a sample how the data looks after import.

Not the usual nice format

 

In DataStudio I canun-nest the data but not in PBI

(I'm a absolute beginner in SQL)

//NOG

 

  • 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