Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cubedweller
Regular Visitor

convert json data into a table

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?

 

Initial screenInitial screenColumnsColumnsDataData

2 REPLIES 2
Phil_Seamark
Employee
Employee

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

 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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?

Converted TableConverted TableRecordsRecords

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.