Skip to content

data-preview.md

Latest commit

 

History

History
42 lines (27 loc) · 2.79 KB

data-preview.md

File metadata and controls

42 lines (27 loc) · 2.79 KB
title View Data in the Data Preview
description Learn about using the Data preview in Microsoft Fabric.
ms.reviewer jacindaeng
ms.date 04/06/2025
ms.topic how-to
ms.search.form Data preview

View data in the Data preview in Microsoft Fabric

Applies to: [!INCLUDE fabric-se-dw-mirroreddb]

The Data preview is one of the three switcher modes along with the Query editor and Model view within Fabric Data Warehouse that provides an easy interface to view the data within your tables or views to preview sample data (top 1,000 rows).

Get started

After creating a warehouse and ingesting data, select a specific table or view from the Object explorer that you would like to display in the data grid of the Data preview page.

:::image type="content" source="media/data-preview/data-preview.png" alt-text="Screenshot of the data grid on the Data preview screen within the warehouse." lightbox="media/data-preview/data-preview.png":::

  • Search value – Type in a specific keyword in the search bar and rows with that specific keyword will be filtered. In this example, "New Hampshire" is the keyword and only rows containing this keyword are shown. To clear the search, select the X inside the search bar.

    :::image type="content" source="media/data-preview/search-bar.png" alt-text="Screenshot of searching New Hampshire in the search bar within the data preview of the warehouse." lightbox="media/data-preview/search-bar.png":::

  • Sort columns (alphabetically or numerically) – Hover over the column title to see the More Options (...) button appear. Select it to see the "Sort Ascending" and "Sort Descending" options.

    :::image type="content" source="media/data-preview/sort-data-preview.png" alt-text="Screenshot of selecting on the context menu within data preview to sort ascending or descending." lightbox="media/data-preview/sort-data-preview.png":::

  • Copy value – Select a specific cell in the data preview and press Ctrl + C (Windows) or Cmd + C (Mac).

Considerations and limitations

  • Only the top 1,000 rows can be shown in the data grid of the Data preview.
  • The Data preview view changes depending on how the columns are sorted or if there's a keyword that is searched.

Related content