Fabric Data Warehouse Writer runtime considerations
Limitations
The following limitations apply to Fabric Data Warehouse Writer:
Auto schema conversion using the wizard is not supported with Fabric Data Warehouse Writer.
Special characters are not supported as a part of table names and schema names.
Schema, table and column names with the same name but different cases are not supported.
Source tables should not have more than 511 columns when using Optimized Merge mode, or 1022 columns when using Merge mode. This is because of Fabric’s limit of 1024 columns per table.