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 it is nested.

How can I un-nest the data?

NOG

Need Help

7 Replies

  • 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