Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to work with MongoDB nested tables in Power BI

in my case, I import data from MongoDB which has nested tables in each record because of this whenever I import the data into power bi I am facing issues with this data format and building analytics on this data. Is there a way to work with nested tables in tested tables in power bi?

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak thanks for your response previously I have done it but I have gone expanding there are so many records for each record the same columns are repeating. As I can say for one record i have 3 columns and for 10 records it is 30 columns like this I am not able to analyze this.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous 

        Table will be expand by row, for example, if you have 3 rows for this table field, and this table contains 3 rows, you will get 3*3 row when you expand.

        Here is a blog about how to work with a List, Record, or Table structured column (Power Query). I hope it could help you solve your problem.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.