---
schema_version: "1"
id: e533eb6f90ce29c2f914e5596c3bf54d34bf6183f734c7aaf8c67f42108ef6bc
title: Set Up the Preview in a Recipe
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_create_recipe_set_preview.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_create_recipe_set_preview.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 09477aacee53f7c5bf1dfd12fe39a27cc6d48075cfa61cd26d4b96dce30729b6
description: A recipe displays a preview of your data on the Preview tab as you work. You can set the columns and number of rows that appear in this preview. If you are working with a large set of data, reducing the size of the preview speeds up the data refresh as you add steps to your recipe.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Set Up the Preview in a Recipe

A recipe displays a preview of your data on the Preview tab as you work. You can set the columns and number of rows that appear in this preview. If you are working with a large set of data, reducing the size of the preview speeds up the data refresh as you add steps to your recipe.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To speed up the preview when you create a recipe, multivalue fields aren’t included by default. The recipe editor hides these fields from the preview because they sometimes cause recipes to yield unexpected results. For example, a recipe with multivalue fields can result in query timeouts or fail to load or run. If needed, you can manually add these fields to the recipe.

If you’re working with a connected object of more than 10,000 rows, CRM Analytics loads a sample of 10,000 rows into the recipe. As you work in a recipe, the sample size used in the preview is always visible at the top of the page. Use the selector to choose to see the first 1000, 5000, or 10,000 rows.

![Recipe sample size indicator](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_preview_indicator.png)

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note Filters that you add in a recipe only apply to the sample data. They don’t result in the recipe editor retrieving an updated sample.

To help you distinguish between nulls and empty strings, the preview shows null values as “null” in gray italics and empty strings as blank values.

![The recipe editor shows empty values for empty strings and "null" for null values.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_recipe_previewWithNulls.png)

If you don’t need a column in your preview, select **Hide Column** from the column menu.

![Hide column option highlighted on column menu](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_recipe_hide_column_option.png)

If you’re working with numerous columns, click the columns tab to work from a list view of columns without the data.

![Columns tab in recipe builder](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_set_preview.png)

All the columns included in your recipe appear first (1), color-coded by source, with their type, the dataset they come from, and a missing values indicator. To find a column, start typing the name in the search box (2) to narrow down the list. To hide a column, click its menu button and select **Hide Column**. Columns that you hide in the recipe appear in a separate list (4). To add one of these columns back, select Add to Recipe from its menu (5).

To work on a column in either the Preview or Columns tab, click it. The column menu options and smart suggestions available are the same on both tabs.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note The recipe preview can display up to 100 fields. If you remove a field from the preview, by default it’s not included in the target dataset. However, you can reselect any field when you create the dataset.