Filter Preview Data in Physical Tables

You can use the table preview tiles to filter column data in the physical table preview. Preview is available for physical tables that use relational data sources.

The tiles area of the table preview only displays if you have the Create and Edit Datasets permission.
  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon.
  4. In the database pane, double-click the table to preview its data.
  5. In the physical table, click the Preview tab.
  6. Hover over a column tile and select a data value to filter the table by.
  7. Locate a column with a details bar that displays red indicating that the column contains invalid values. Hover over the tile's title and click the filter icon Filter iconand select if you want to filter the table by the column's valid or invalid or missing values.
  8. Remove filter values by hovering over any column, click the filter icon Filter icon, and select Clear Filters.