Skip to main content

Refreshing Dataset Schemas

The schemas for database tables and views can change over time. Design Center allows you to refresh your datasets to pick up recent changes from the data warehouse; for example, if new columns were added.

Before you begin​

When refreshing dataset schemas, be aware of the following:

  • If the schema for the source data changes, you should first update the table definition in the data warehouse, then refresh the dataset schema in Design Center to get the latest dataset columns from the table definition.
  • If existing column names change, you may need to manually fix relationships and calculated column formulas that use the old column names.
  • For query-based datasets (QDSs), if the name of the table changes in the data warehouse, you must update it in the selection SQL for the QDS before refreshing the schema.

Refresh a dataset schema​

  1. In Design Center, go to the Workspace panel.

  2. Locate the dataset you want to refresh, click its context menu and select Refresh Dataset.

    The context menu for a dataset, with the Refresh Dataset option highlighted.

The dataset updates with the latest changes from the data warehouse.