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)

No change in size , 30 July

no edit summary

3,301

edits

@@ 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'''.
-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.
+By using Power Query's native ability to Transform your data, and specifically the [https://learn.microsoft.com/en-us/powerquery-m/table-expandtablecolumn Table.ExpandTableColumn] and [https://learn.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn Table.ExpandRecordColumn], you can show and include these hidden fields in your Excel or Power bi Reports.
 = Steps =