Forum Discussion
Show actual values in table column
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.
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,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
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
v-henryk-mstfCommunity Support
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,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
