Unable to Open Semantic Model

[Anonymous]

Hello Everyone!

I recently deployed a semantic model on Fabric using Tabular Editor, with the connection to an on-prem SQL database in Import Mode.

While I am able to refresh the model and create reports, I encounter the following error when trying to open the data model:

Underlying Error: {"code":"ExternalServiceFailed","pbi.error":{"code":"ExternalServiceFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"Error in ModelingEngineHost"}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"ModelingEngineHost"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"InvalidOperationException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"Sequence contains more than one element"}}]}}

Does anyone know the cause of this issue?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Deku  for the helpful response.

Please follow below steps to resolve the issue;

1.Look for duplicate partitions, roles, KPIs, tables, or measures with the same name.

2.Use Tabular Editor’s "Validate Model" feature before deploying to catch any structural issues early.

3.Opening the model locally may reveal more detailed validation errors.

4.If the issue persists, export objects and rebuild the model from scratch to eliminate any corrupted or invalid metadata.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[Anonymous]

Hi @Anonymous,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @Anonymous,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @Anonymous,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous · Accepted solution]

Hi @Anonymous,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Deku  for the helpful response.

Please follow below steps to resolve the issue;

1.Look for duplicate partitions, roles, KPIs, tables, or measures with the same name.

2.Use Tabular Editor’s "Validate Model" feature before deploying to catch any structural issues early.

3.Opening the model locally may reveal more detailed validation errors.

4.If the issue persists, export objects and rebuild the model from scratch to eliminate any corrupted or invalid metadata.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[Anonymous]

Thank you so much for your reply.

I’ve identified that the issue is related to partitioned tables. For example, when I load only the dimension tables (each with a single partition), the model opens without any issues. However, when I include the Fact table — which contains multiple partitions — the model fails to open.

The challenge is that my model uses Import storage mode, and the data source is on-premises. Partitioning significantly benefits this setup, especially for managing data refresh performance and volume.

Do you have any suggestions on how to handle this, or best practices for working with multiple partitions in Import mode?

[Anonymous · Accepted solution]

Hi @Anonymous,

Thank you for reaching out in Microsoft Community Forum.

Please follow below steps for Partitioned Tables in Import Mode;

1. Make sure each partition has a unique name and non-overlapping data range — duplicate or conflicting partitions can cause model load issues.

2.Use Tabular Editor’s “Validate Model” feature to check for partition or metadata issues before deploying.

3.Test partitions incrementally — start with just one or two and add more gradually to identify any specific problematic partition.

4.Stick to a clear partitioning strategy (e.g., monthly slices with filters) and avoid empty or invalid partitions that may cause errors during model load.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[Deku]

What do you mean by trying to open the data model?

[Anonymous]

On the Fabric page, there is the "Open Data Model" option. However, when I try to open it, I get the error I mentioned in the post.

[Deku]

Are you referencing the same table multiple time. Found a comment on this blog

https://www.google.com/amp/s/blog.crossjoin.co.uk/2024/09/29/role-playing-dimensions-in-fabric-direc...