Forum Discussion
Advocate IIICopy Data failure to lakehouse: sql server column names with spaces
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.
Super UserThat is a well known limitation. Remove the spaces from the table names and column names.