Forum Discussion
Expanding Table Button Missing for nested XML data table
Hello dear forum users, I have read in XML data into Power BI desktop. The XML data has three layers of nest tables (parent record>child>subchild). I can open and expand most of the nest tables. ...
You can't expand something that's not there. Filter out the null values or replace them with fake (but expandable) tables.
Hi lbendlin , thanks for your reply.
I don't think it is feasible to filter out the null values since these records have non-missing values in other fields. So I will need to replace them with fake tables of the same structure. I googled for some info on how to do this, but did not find anything useful. Would you please give me some specific instructions on how to fill in the fake tables?
Thanks a lot.