Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I imported a json file and a table appeared with rowcount=394, columns=List, and data=Record ("Initial screen" image below).
The "Columns" screen capture shows the result for when I clicked on "List".
The "Data" screen capture shows the result for when I clicked "Record".
How do I convert this data into a table?
Hi @cubedweller
Right-click a few places in the Power Query data viewer (column header/record cell) and you may see the "Into Table" option in the menu that pops up. Or check for a "Convert" table in your ribbon
OK, I clicked "Into Table" on the Convert tab (see screen capture below).
The screen capture below that one ("Records") shows the outcome when I click on "Records".
How should I proceed?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |