Forum Discussion
Collation Error while reading data form SQL Endpoint of Lakehouse
Not sure if the following solutions from SQL Server would work or not. It seems the solutions require you to set the collation for every column. You may give this a try.
sql server - SQL change field Collation in a select - Stack Overflow
t sql - Can I specify the collation when performing a SELECT INTO - Stack Overflow
However the column collation documentation seems not applied to Fabric currently. And this thread also mentions this limitation. So above solutions might be not supported. I haven't tested it, to be honest.
At the moment, the collation option in Fabric is only warehouse-wide and cannot be changed once the warehouse is created. How to: Create warehouses with case-insensitive (CI) collation - Microsoft Fabric | Microsoft Learn
Best Regards,
Jing
Community Support Team