Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |