lakehouse table duplicates all rows when added to semantic model

[SCWO]

Hello together,
I'm facing a problem which I could not find the reason for.
I have a table linked from a Warehouse into a lakehouse. When I query the table in sql endpoint the number of rows in the table is 1629. I added this table to a semantic model. When I query that table in DAX Studio the number of rows has doubled. 
When I have a closer look on the data I notice, that every row is duplicated. Checking the source table in the lakehouse shows that my id column has only unique numbers but the table in the semantic model has duplicated ids.
I tried to delete the table from the model and adding it again but the problem is the same.

Has anybody an idea what I could have done wrong or where to search for the reason?

BR Wolfgang 

[alia12]

Yeah, I ran into this once. In my case, the issue was related to how the table got joined or loaded in the model. First thing I'd check is whether the table was accidentally marked as both import and DirectLake at the same time (some Fabric models can silently do that if the dataset isn't cleaned properly before refresh).

Another thing: if your semantic model has auto-detect relationships enabled, it could have created a loop or many-to-many relationship that's effectively duplicating rows on join. I'd also check in Power BI Desktop model view for hidden relationships or inactive ones that got activated during refresh.

If none of that helps, try creating a brand-new model, link only that table, and see if the issue persists, that usually helps isolate whether it's the data or the model config.