Difference between revisions of "Display missing data/fields in Microsoft Excel and Microsoft Power BI"

Jump to navigation Jump to search
no edit summary
m (added break point in related links)
Line 19: Line 19:
# 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.
# Once you've expanded all the required columns, click on '''Close & Load" button in the '''Home''' Menu
# Once you've expanded all the required columns, click on '''Close & Load''' button in the '''Home''' Menu


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.
Write
74

edits

Navigation menu