View data in the Data preview in Microsoft Fabric

Applies to: ✅ SQL analytics endpoint, Warehouse, and Mirrored Database in Microsoft Fabric

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).

• You can also query the data in your warehouse with multiple tools with a SQL connection string.
• You can use the SQL query editor to write T-SQL queries from the Microsoft Fabric portal.
• You can build queries graphically with the visual query editor.

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.

👁 Screenshot of the data grid on the Data preview screen within the warehouse.

• 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.

  👁 Screenshot of searching New Hampshire in the search bar within the data preview of the warehouse.
  

• 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.

  👁 Screenshot of selecting on the context menu within data preview to sort ascending or descending.
  

• 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

• Semantic models in Microsoft Fabric