Display missing data/fields in Microsoft Excel and Microsoft Power BI

From OdataLink
Revision as of 03:47, 25 July 2024 by Ash (talk | contribs)
Jump to navigation Jump to search

OdataLink provides the data as an OData feed which is generally hierarchical or nested in nature.

By default, Microsoft Excel and Microsoft Power BI display only the header or the first-level columns and hide nested columns.

These hidden or nested fields are referred to as Record and can be expanded in Power Query Editor.

Steps

  1. Open Power Query Editor:
  2. A new dialog box will appear with all the Tables on the left side.
  3. Navigate to the Table which contains the nested column.
  4. Nested columns will be displayed with an Expand button beside the column name.
  5. 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.
  6. 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.

Tutorial

Here is a video from Nic explaining the process in Power BI


Related Topic

Linking your data to a Standard Microsoft Power BI Report
Linking your data to a Standard Microsoft Excel Report