When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema

[WithwindOK]

When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema.When the table name contains the character '.', an error will occur.

[v-nuoc-msft]

Hi @WithwindOK 

The error message indicates that the table name contains invalid characters, specifically a period (.), which is not allowed. When writing to a Lakehouse target table using Dataflow Gen2 in Microsoft Fabric, you can follow these steps to resolve this issue:

Make sure that the table name contains only valid characters: letters, numbers, underscores (_), and cannot end with a space.

If you need to include a schema (such as ShangWuUser), define the schema separately in the Dataflow Gen2 settings instead of embedding the schema name directly into the table name.

About specifying the target schema in Dataflow Gen2:

In the target settings of Dataflow Gen2, you can select an existing table or create a new table. If the target table supports schemas, you can specify the schema when connecting.

If the table name contains invalid characters (such as .), the system automatically adjusts the table name to conform to the naming rules of the target.

Please refer to the following links:

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WithwindOK]

Hi @v-nuoc-msft 

Excuse me,Where can I choose or set the  schema (such as ShangWuUser)? I didn't see it in the wizard, and it wasn't mentioned in the linked documentation.Would you give me a screenshot of the schema.Thanks.

[v-nuoc-msft · Accepted solution]

Hi @WithwindOK 

Update to the above link:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

By default, it is placed in the dbo schema. You can drag and drop it into the target schema.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.