Forum Discussion
Advocate IIICopy Data failure to lakehouse: sql server column names with spaces
we have an onprem sql server, In Fabric, a gateway connection is configured to the server.
Now I have a pipeline with a Copy Data configured with source as this sql server and target as the fabric lakehouse.
Some of the sql tables have space in the column names and the Copy Data fails saying
Failure happened on 'destination' side. ErrorCode=DeltaInvalidCharacterInColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column name Default Create Configuration Code contains invalid characters. ",;{}()\n\t=" are not supported.,Source=Microsoft.DataTransfer.ClientLibrary,'
anyone faced this issue before please suggest
thanks
Hi msprog ,
Thank you for reaching out to the Forum community.This error occurs because Fabric Lakehouse (Delta tables) does not permit spaces or special characters in column names. To fix it try In the Copy Data activity, navigate to the Mapping tab. Map the source columns to target columns using valid names (replace spaces with underscores or remove special characters).
Example: Default Create Configuration Code to -> Default_Create_Configuration_CodeAlternatively, you can use a SQL query or view to rename the columns before copying.
Try updating to the latest gateway version (v3000.286.14) and test again.
If you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with Microsoft Support.Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnRegards,
Sreeteja.
9 Replies
ForwardArsenal7Microsoft Employee
The latest release of OPDG (version 3000.286.14) addresses this issue. Please download it here.
Hi ForwardArsenal7 ,
Thanks for your update.
msprogthanks ForwardArsenal7 please can you point me to any doc that says it is addressed please. just wanted to see the features in the .14 release pls, so i can take it to my stakeholders. thanks
- lbendlin
Super User
That is a well known limitation. Remove the spaces from the table names and column names.
Hi msprog ,
Thank you for reaching out to the Forum community.This error occurs because Fabric Lakehouse (Delta tables) does not permit spaces or special characters in column names. To fix it try In the Copy Data activity, navigate to the Mapping tab. Map the source columns to target columns using valid names (replace spaces with underscores or remove special characters).
Example: Default Create Configuration Code to -> Default_Create_Configuration_CodeAlternatively, you can use a SQL query or view to rename the columns before copying.
Try updating to the latest gateway version (v3000.286.14) and test again.
If you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with Microsoft Support.Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnRegards,
Sreeteja.Hi msprog ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Hi msprog ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Hi msprog ,
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.
