Issue with Editing Custom Semantic Model in Microsoft Fabric – Resolved

[dinuravimukthi]

I created a custom semantic model for one of my Fabric projects. All tables were stored in a Fabric lakehouse, and everything worked fine, including a PBI dashboard. However, when I tried to add a new table later, I realized that I could no longer edit the model.

I was unable to add or remove tables using the 'Edit tables' option. However, I could still delete existing tables from the model layout (three dots -> 'Delete from model'). Each time I attempted to edit the model, I encountered the following error message:

Something went wrong

Something went wrong connecting to this item in the Fabric portal. You can open the item in your browser to see if there is an issue or try again later.
Please try again later or contact support. If you contact support, please provide these details.
Hide details
Activity ID  #######
Request ID  #######
Correlation ID  #######
Time  Wed Mar 19 2025 09:15:35 GMT+0530 (India Standard Time)
Service version  13.0.25498.40
Client version  2503.2.23230-train
Cluster URI #######

ISSUE
The root cause was a relationship in the existing model defined between two columns with different data types:
Eg: A.dateKey (datetime) -> B.date (string)

I’m not sure how I was able to create this relationship in the first place because when I tried to replicate it in a separate semantic model for testing, Fabric raised an error, preventing mismatched data types in relationships.

SOLUTION
To resolve the issue, I modified the schema of one of the affected tables by changing the data type to match the other one:
B.date (string) -> B.date (datetime)

After overwriting the schema of the relevant table, I was able to edit the semantic model without issues.

[ECleal]

Thankyou for posting this! I have the same error and the vague error message was driving me mad. I found that trying to refresh the model from the whirly arrow logo in the workspace view (when viewing the list of items, not with the model open) gave me a different and slightly more helpful error message that told me which table is the issue.

Time to do some more digging!

[dinuravimukthi]

Glad to hear this helped! Yeah, that vague error message was giving me a headache too. That’s a great tip, getting an error message telling which table is the issue can save so much time. Otherwise we'd have to go through every relationship manually.

[v-prasare · Accepted solution]

@dinuravimukthi,

Thanks for actively engaging in MS Fabric community support

your valueble inputs for Issue with Editing Custom Semantic Model in Microsoft Fabric help other community members with similiar questions, i request you to please acceept this post as solution so, the other users with similar questions find answers quikly.

Thanks,

Prashanth

MS Fabric community