In excel, I have a power query which loads a table with nested tables. In the query editor window, I can click the Table and drill down which is great.
Problem is, when I do save and close, and return to the regular excel view, and I see the table there, the nested tables, show as "Table" like a literal string. And if I click it, nothing happens, since it is just a string.
I would like it to open up the nested table in a new sheet for example.