Issues editing default semantic model or creating a new semantic model

[wilson_smyth]

Hi.

When i try to hide a table in the default semantic view i get the below error:

"code":"ArgumentException","message":"Item '<ccon>InteractionCategory</ccon>' already exists in the collection"

I then tried to create a new semantic model, but I cant create one at all due to the error:

I am 100% sure nobody else and no other processes are running in the workspace or against the capacity.
I cant raise a support request as Microsoft now require a Premier Support Contract.

Another user operation is already running. Wait for a few minutes, then refresh and try again.

Would appreciate some advise on what to try next.
The whole platform is a great idea but seems incredibly unstable and is eating up peoples time with these errors.

Appreciate any guidance that can be given, thank you.

[Anonymous]

Hi @wilson_smyth 

Is InteractionCategory an object you chose to add to the semantic model? Please check if there are any objects with the same name (possibly with different casing) among the ones you selected to add. This is probably the cause of this error. 

Here's why: 

In Microsoft Fabric, table (and view) names in data warehouses and lakehouse are case-sensitive. This means that when querying and operating on tables, you must match the case of the table names exactly. For example, SalesData, salesdata, and SALESDATA are considered different names. 

However, table names in the semantic model are not case-sensitive. This means that SalesData, salesdata, and SALESDATA would be considered the same table.

To resolve this, you need to rename one of the tables (or views) before adding it to the semantic model where another table with the same name already exists. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!