Show actual values in table column

[rinabernardo]

After using a web data source, the values of one column is displayed as [Table], however, when clicking on [Table], the actual value is shown. How can I get the actual value to show up in the main table.

[v-henryk-mstf · Accepted solution]

Hi @rinabernardo ,

When a column of the imported data source is of table type, to view the specific table content, you can only manually click to expand in Power query, and the table content will not be automatically expanded when importing.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@rinabernardo , Open power query check do you see any expand icon on the column , if yes expand to rows or columns.

Refer this video on Json, for what option you get  in such cases

How to import JSON Data: https://youtu.be/MPYfEetvFH4