Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide

Making a Microsoft Fabric Warehouse case insensitive is a decision you can make before building your data platform.

If Customers does not equal customers in your queries, your Warehouse is case sensitive. The solution is simple. You just need to configure the correct setting at the Workspace level.

---

Why Configure a Microsoft Fabric Warehouse Case Insensitive?

In a case sensitive Warehouse, capitalisation matters:

• Sales is different from sales
• CustomerID is different from customerid
• 'ABC' does not equal 'abc'

Queries must match exact capitalisation. Even small differences can cause failed joins, empty results, and Power BI issues.

In contrast, a Microsoft Fabric Warehouse case insensitive setup ignores capitalisation differences. Development becomes smoother and more predictable.

---

Where to Enable Case Insensitive

Case sensitivity in Fabric is controlled at the Workspace level, not at the table level. Therefore, you must configure it before creating your Warehouse.

Follow these steps:

1. Open your Fabric workspace
2. Select Workspace Settings
3. Navigate to Data Warehouse
4. Click Collations

You will see two options:

• Case sensitive (Latin1_General_100_BIN2_UTF8)
• Case insensitive (Latin1_General_100_CI_AS_KS_WS_SC_UTF8)

To enable a Microsoft Fabric Warehouse case insensitive configuration, select:

After that, all new Warehouses in the workspace will inherit this behaviour.

---

 

This Setting Only Applies to New Warehouses

The setting only affects newly created Warehouses, since collation is locked at creation and cannot be changed later.

If you already created a case sensitive Warehouse, you must update the Workspace setting, create a new Warehouse, and migrate your data.

---

Why Case Insensitive Is Recommended for Most Teams

For most BI, analytics, and Azure SQL migration scenarios, this setup reduces query errors, improves consistency, and simplifies development.

---

Final Thoughts

Ultimately, configuring a case insensitive environment is a small decision with a significant impact. Because the setting lives at the Workspace level, it should be chosen before creating your Warehouse.

Set it correctly early, and your Fabric environment will behave consistently

For documentation on SQL collations, see: Data Warehouse collation – Microsoft Fabric | Microsoft Learn