DW in FABRIC ERROR: Sequence contains more than one matching element

[EslamGharib]

{"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 matching element"}}]}}}

I get this error when I try to "Edit tables" in my semantic model tab to include a new table that I've added in the DW. When I click the button to add it then confirm, the error shows. Some tables, In my semantic model, use Direct query mode and others use import mode. I've tried refreshing the schema in the DW but it didn't fix it.

[v-veshwara-msft]

Hi @EslamGharib ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.

Thanks @BhaveshPatel for sharing your valuable insights.

Thank you.

[v-kpoloju-msft]

Hi @EslamGharib,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[BhaveshPatel]

Hi @EslamGharib 

so, The problem is Composite model . We have to apply our logic here. In Fabric DW, Composite model ( Import + Direct Query mode ) was there which was failing because we were trying to solve composite model problem. Instead, use Direct Lake approach in Fabric DW and you can edit Tables or add new tables as well. 

[v-veshwara-msft · Accepted solution]

Hi @EslamGharib ,

Thanks for reaching out to the Microsoft Fabric Community.

This error usually occurs when the semantic model encounters duplicate metadata while processing tables. It can happen if there are duplicate table or column names, conflicting relationships, or a mix of Import and DirectQuery tables that the modeling engine cannot handle together.

Please check if any tables or columns share the same name, remove and re-add the new table, and review the relationships to ensure there are no duplicates. If the issue continues, try adding the table in a model using a single mode (all Import or all DirectQuery) to isolate the cause.

For reference, similar issues have been reported in these discussions:

Issue with Power BI 'Sequence contains more than o... - Microsoft Fabric Community

Sequence contains more than one matching element - Microsoft Fabric Community

Error: Sequence contains more than one matching el... - Microsoft Fabric Community

If the issue continues, please share details about your DW schema or model setup for further review.

Hope this helps. Please reach out for further assistance.

Thank you.