Forum Discussion
Primary Key Duplicate Detection in Data View, not Power Query
Hi all, I'm having an issue with primary key duplication detection in data view but not power Query. The source of the data is a lookup table that is stored in an on-premises database, which doe...
"when I run a dax query to locate distinct values, one of the two is removed" - can you show me this please?
--
I would need to see the other tables and relationships (and error messages) to get any further with that example 1
--
For example 2, I'm not really understanding the issue. It's certainly possible for 2 similar pieces of data to be treated as different if, for example, there are hidden special characters. However, this is quite unusual and can be sorted out with a Trim and Clean in Power Query.
Maybe you can post your pbix, it would save time.