Excel Power Query - Nested JSON and never end Records
From Solved: Nested JSON and never end Records - Microsoft Fabric Community Nested JSON and never end Records 02-27-2017 06:43 PM Afternoon, I have a json file ( https://1drv.ms/u/s!At8Q-ZbRnAj8hkJLL1cyU4t_hoHC ) which has many nested arrays and I'm unsure of how to extract all of the records into powerbi. I've watch the guyinacube video (incredibly helpful), but I get to a point where I can't expand my columns any further yet I need the data inside that record (it's actually the data I want). First step: https://gyazo.com/86e411d5de9d7f2f52813f6f66cb3bf9 Convert to table, easy it converts out to this. Second Step: https://gyazo.com/546206f9a6b0459a4a09b2c865c3d902 Expand out, again comfortable. Expand again. Third Step (issue): https://gyazo.com/ffe36ce86fa91f4ae0a435c524d026e5 The column on the far right is the colum which contains the data that i want, but I'm unable to retrieve the data from that column without individually clicking on the link