COlumns of Type "Table" from a Sharepoint list removed from Dataflow
I was getting a lot of 429 type error from a Sharepoint site/list given the number of readings by PowerBI in a day, so I decided to use a Dataflow to connect to it (refreshed once a day) and feed my PowerBI reports from there.
However, I would like to keep some of the nested table columns from the Shaprepoint list (online in my case). PowerQuery Online is removing them automatically, no matter what I do.
The code here below gets generated by Powerquery upon saving and exiting my dataflow, to impose a type to the columns.
How can I get over this? Is it possible for my databaflow to contain columns of nested tables/records?