Write
280
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 02:47, 25 July 2024
, 25 Julyno edit summary
m |
|||
| 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 nested fields can be expanded | These hidden or nested fields are referred to as [[Field Type: Record|Record]] and can be expanded in '''Power Query Editor'''. | ||
= Steps = | = Steps = | ||
| Line 12: | Line 12: | ||
--> | --> | ||
# Open '''Power Query Editor''': | |||
#* [[Microsoft Power BI]] Users: Click on '''Transform Data''' button in Home menu. | |||
#* [[Microsoft Excel]] Users: Click on Data > Get Data > '''Launch Power Query Editor'''. | |||
# | # A new dialog box will appear with all the Tables on the left side. | ||
# Navigate to the | # Navigate to the Table which contains the nested column. | ||
# Nested columns will be displayed with an '''Expand''' button beside the column name. | # Nested columns will be displayed with an '''Expand''' button beside the column name. | ||
# Upon clicking the '''Expand''' button, all the nested fields will be displayed as a list. Select the columns you want by clicking on the check box beside the field names. | # Upon clicking the '''Expand''' button, all the nested fields will be displayed as a list. Select the columns you want by clicking on the check box beside the field names. | ||
| Line 22: | Line 22: | ||
Once completed, you will be able to view the nested columns in your report. | Once completed, you will be able to view the nested columns in your report. | ||
= Tutorial = | |||
Here is a video from Nic explaining the process in Power BI | |||
<br /> | |||
{{#ev:youtube|lE2nPwS1lXA|dimensions=720x480}} | |||
= Related Topic = | = Related Topic = | ||