New Fabric item module for data destinations

The New Fabric item module creates a Fabric item to use as a destination. Use it when you need a new destination container rather than an existing item.

Screenshot of the New Fabric item form with Type, Workspace, and Name fields.

Choose the item's Type, Workspace, and Name, and complete any additional settings shown. The preceding screenshot shows Lakehouse, Warehouse, and SQL database choices. The host determines the available types and options.

You need permission to create the selected item in the target workspace and write data to the destination. Creating a destination item doesn't by itself load data into it.

This module appears in supported destination-selection experiences. It isn't a way to select the source data that your query reads.

Choose the item to create

  1. When selecting a destination, open New Fabric item.
  2. Select the item type supported by your scenario.
  3. Choose the workspace where the item should be created.
  4. Enter a name and complete any additional settings shown for that item type.
  5. Follow the creation prompts, then continue configuring the query's destination.

If you already have an appropriate destination, select that existing item instead of creating another one.

Creating an item isn't the same as loading data

The Fabric item is the container for your output. You still need to configure the destination target and load settings, such as a table, column mappings, and the supported update method.

In Dataflow Gen2, destinations apply to tabular queries, not functions or lists. When you choose a new destination table, Dataflow Gen2 creates that table during refresh. Creating a Fabric item and creating a table inside it are separate operations.

For the complete destination workflow, go to Dataflow Gen2 data destinations and managed settings. To discover existing data items, use OneLake catalog.