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.
I have a table that contains a JSON Blob in one of it's columns. Can I extract the data into a tabular format?
Thanks!
Solved! Go to Solution.
Hi @data4thewin,
Perhaps you can refer to below sample file.
BTW, if you want format multiple records, I'd like recommend you use the records which has similar structure.
Regards,
XIaoxin Sheng
Hi @data4thewin,
Since each row has different element, I'd like to suggest you convert these to multiple tables with different structure.
After format these tables, you can use table.combine function to merge them.
Regards,
Xiaoxin Sheng
How would I get started converting them to multiple tables?
Hi @data4thewin,
Perhaps you can refer to below sample file.
BTW, if you want format multiple records, I'd like recommend you use the records which has similar structure.
Regards,
XIaoxin Sheng
Thank you!!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |