Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. But a few of the tables have missing values (some rows don't have the table, either missing or blank). I can open and see the separate tables. But I cannot expand the table as separate fields., becauseI don't see the Expanding Table button behind the column name. Please see the screenshot of the Query table window below.
Is there anyway I can expand this table column? Your suggestions/advice is highly appreciated.
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.
use #table and specify the same column names as in the "real" tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |