Write
74
edits
Difference between revisions of "Display missing data/fields in Microsoft Excel and Microsoft Power BI"
Display missing data/fields in Microsoft Excel and Microsoft Power BI (view source)
Revision as of 21:09, 30 July 2024
, 30 Julyadded details based on Nic's suggestions
(changes based on Nic's suggestions, title name pending) |
(added details based on Nic's suggestions) |
||
| Line 3: | Line 3: | ||
By default, [[Microsoft Excel]] and [[Microsoft Power BI]] display only the header or the first-level columns and hide nested columns. | By default, [[Microsoft Excel]] and [[Microsoft Power BI]] display only the header or the first-level columns and hide nested columns. | ||
These hidden or nested fields | These hidden or nested fields can either be [[Field Type: Record|Records]] or [[Field Type: Table|Tables]] and can be expanded in '''Power Query Editor'''. | ||
By using Power Query's native ability to Transform your data, and specifically the Table.ExpandTableColumn [https://learn.microsoft.com/en-us/powerquery-m/table-expandtablecolumn] and Table.ExpandRecordColumn [https://learn.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn], you can show and include these hidden fields in your Excel or Power bi Reports. | |||
= Steps = | = Steps = | ||