PowerBI Columns Not Showing in Data Sidebar

Check the missing columns in Model view and turn off Is hidden; if they are not present there at all, return to Power Query and use Close & Apply to load the current 92-column schema into the semantic model.

1. Determine whether the columns are hidden

Power Query preview and the Data/Fields pane represent different layers: the query output versus the loaded semantic model. Columns can remain in the model while being hidden from the report field list.

1. In Power BI Desktop, select Model view from the left navigation.
2. Expand cdi_sentemail.
3. Search for an exact missing name, such as cdi_subject or cdi_deliveriescount.
4. If the column appears with a crossed-out eye:
   • Select the column.
   • In Properties, set Is hidden to Off; or
   • Select the Eye icon and choose Show in report view.

Power BI documents the eye icon and Hide in report view behavior; hidden columns remain in the model but do not appear in the report field list.^1^

Return to Report view and verify that the column now appears in the Data pane.

The list in the screenshot is scrollable and appears alphabetically arranged. Search for the exact column before relying on a manual count. Also note that some technical names may have been renamed—for example, cdi_bouncescount and cdi_clickscount appear to correspond to Bounces and Clicks.

2. If the columns do not exist in Model view

The current Power Query schema has not yet reached the semantic model.

1. Select Home → Transform data.
2. Select cdi_sentemail.
3. In Applied Steps, select the final step—not only Source.
4. Confirm that all 92 columns still exist in that final output. A later step such as Removed Columns, Choose Columns, Expanded…, or Renamed Columns can change the schema loaded into the model.^2^
5. Select Home → Close & Apply. This applies the transformations and loads the shaped table into the Power BI semantic model.^3^
6. After processing completes, return to Model view, expand cdi_sentemail, and search for the missing fields again.

If Close & Apply reports an error, inspect the affected Applied Step for renamed/missing columns, type conversion failures, or source schema changes before retrying.

3. If Model view still contains only 72 columns

Verify that the displayed cdi_sentemail table is loaded from the query being edited rather than from a separate or older source connection. A closely matching reported case was resolved by replacing a model table loaded directly from its source with one loaded from the Power Query output.^4^

Before deleting or recreating anything:

• Save a backup copy of the .pbix.
• Check whether another query or table has the same or a similar name.
• Confirm that cdi_sentemail is enabled for loading.
• Preserve measures and relationships before replacing a model table, because deleting it can break dependent model objects.

The Show Hidden Datasets command sometimes suggested online applies to paginated Report Builder datasets, not the Power BI Desktop Data pane, so it is not applicable here.

References

1. Tutorial: From dimensional model to stunning report in Power BI Desktop
2. Shape and combine data in Power BI Desktop
3. Power Query get data experience overview
4. Column Added to Power Query Table Not Displaying in Power Pivot - Microsoft Q&A