Forum Discussion
lakehouse table duplicates all rows when added to semantic model
Hi SCWO ,
Thanks for the update.
Good to hear that re-creating the table in the silver layer fixed it. It’s possible that the table had some leftover data or files, and the semantic model picked up the same data more than once.
Re-creating the table gave it a clean state, so the duplicates were no longer there.
Thanks for sharing what worked - it’ll help others as well. Please consider marking the reply as the accepted solution to make it easier for others to find.
Thank you.
Community SupportHi SCWO ,
Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries.
Otherwise, feel free to reach out for further assistance.
Thank you.
Hi,
I still had some troubles with the semantic model and I wasn't able to fix the problem getting the result of doubled rows in my reports.
My first thought that the problem was gone with creating a new semantic model was wrong.
I was able to fix the problem after I deleted the table in my silver layer and created it again.
Afterwards my results in the report where right.
- v-veshwara-msft
Hi SCWO ,
Thanks for the update.
Good to hear that re-creating the table in the silver layer fixed it. It’s possible that the table had some leftover data or files, and the semantic model picked up the same data more than once.
Re-creating the table gave it a clean state, so the duplicates were no longer there.
Thanks for sharing what worked - it’ll help others as well. Please consider marking the reply as the accepted solution to make it easier for others to find.
Thank you.