Flattening an 'n' level JSON file

Since you only provided an image and not the json file, I couldn't try this out directly, but you should be able to do the following

- in the query editor, connect to the file as text instead of json

- use Text.Select to keep just numbers, letters and ":"

- filter out the rows that aren't your 8 repeating value pairs (account, project, type, etc.)

- split the column at the ":"

- add a column that creates an "index" with repeats of 8 (1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,3,3 ...)

- pivot the data to get your desired result

Regards,

Pat