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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.