Forum Discussion
JSON importing - expanding list
Hello community, I have a problem when importing JSON files which I have searched for extensively online but can't find the correct answer to. I have imported a JSON file which in the Query E...
Any help would be greatly appreciated. My project can't move on without this problem being solved.
The code can vary depending on the final table you want to construct.
With a bit of Python script I built the below table from your json, you can download the pbix file here:
https://1drv.ms/u/s!AiiWkkwHZChHj2KndK81exhzMN8N
Thank you, LivioLanzo
Looks like a neat piece of coding, but something I can't replicate myself. This is just an example file, which is a segment of the whole table and then I have 5 tables in total. Although this works I'm afraid it isn't a lasting solution for us, do you know of any other way to solve this issue, without the use of Phyton? Or are there no other options as richbenmintz pointed out.