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

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.