Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Multi dimensional JSON file to one flat table

I have a multi-dimensional table from a json source that I'm trying to convert into one flat table. I can expand the columns up to a point, and still have tables within rows as in the below: 

 

 

The problem I'm having is that when I expand these tables e.g. in the parent column, it opens them up as another seperate table. See example below: 

 

 

Is there a way to automatically expand these tables within the original query instead of having each table expand into a new seperate table view? 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Lydia

     

    The end solution that worked was to have the json data coming through via an API "flattened" by our developer to provide a simpler table for analysis. I ended up not working with the issue in Power BI as there was another solution in code.  

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Lydia. I tried this solution but got an error message when trying to apply it:

       

      Expression.Error: We cannot convert a value of type Table to type List.
      Details:
      Value=Table
      Type=Type

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

        Could you please post the JSON code so that I can  test?

        Regards,
        Lydia