Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Jotheesh
Frequent Visitor

Duplicate table names with different case sensitivity in data warehouse

Hi
Data Warehouse let's me create two tabls with same name but with different case but then gives me error while refeshing teh schema.

I have created tables 

[dbo].[Table_a] and 
[dbo].[TABLE_A] and agen I try to refesh tables in side pane , it gives me below error
Jotheesh_0-1700194589953.png

If we are not supposed to create two tables with same name, should't it be restrcited while attempting to create?

1 ACCEPTED SOLUTION

Hi @Jotheesh  @AndyDDC 
Apologies for the issue you have been facing. This is a known issue. The object explorer fails to display the Fabric Data Warehouse objects (ex. tables, views, etc.) when have same noncase sensitive names. The internal team is working to fix this. Appreciate your patience.
Please refer to this link for more information: Link1

Hope this helps. Please let us know if you have any further issues.

View solution in original post

4 REPLIES 4
Jotheesh
Frequent Visitor

thanks for the update @v-nikhilan-msft 

AndyDDC
Most Valuable Professional
Most Valuable Professional

Yes it's annoying at the moment that we can't choose a collation. I have an Idea here to upvote https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8b35ca62-1117-ee11-a81c-000d3a01b048

v-nikhilan-msft
Community Support
Community Support

Hi @Jotheesh ,
Thanks for the ask and using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Appreciate your patience.
Thanks 

Hi @Jotheesh  @AndyDDC 
Apologies for the issue you have been facing. This is a known issue. The object explorer fails to display the Fabric Data Warehouse objects (ex. tables, views, etc.) when have same noncase sensitive names. The internal team is working to fix this. Appreciate your patience.
Please refer to this link for more information: Link1

Hope this helps. Please let us know if you have any further issues.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.