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)

183 bytes added , 25 July

changes based on Nic's suggestions, title name pending

Write

74

edits

@@ Line 16: / Line 16: @@
 #* [[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 Table which contains the nested column.
+# Navigate to the Table which contains the [[Field Type: Record|Record]] column.
-# Nested columns will be displayed with an '''Expand''' button beside the column name.
+#* ''Please note that you can find more information on sub-fields within endpoints by referring to the endpoints' documentation.
-# 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.
+# [[Field Type: Record|Record]] columns will be displayed with an '''Expand''' button beside the column name.
+# Upon clicking the '''Expand''' button, all the sub-fields will be displayed as a list. Select the columns 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 completed, you will be able to view the nested columns in your report.
+Once the table refresh is completed, you will be able to view the hidden columns in your report.
 = Tutorial =
@@ Line 29: / Line 30: @@
 {{#ev:youtube|lE2nPwS1lXA|dimensions=720x480}}
 = Related Topic =