Write, Bureaucrats, Administrators
3,301
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 Julyno edit summary
m (Nic moved page Display missing data/fields in Microsoft Excel and Microsoft Power BI. to Display missing data/fields in Microsoft Excel and Microsoft Power BI without leaving a redirect) |
|||
| Line 5: | Line 5: | ||
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'''. | 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 | 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 = | ||