I'm having an issue with Duplicate values. I get transactional data from Azure and the raw data comes in with approximately 150 columns of data. This data is then abbreviated into a table used for reporting that only has 32 columns. There should not be any duplicate values in this data, but I realized earlier this week that it was incorrectly removing some data. There is a column that we are not bringing into the smaller, abbreviated table that allows the rows to be differentiated from one another, but without that it is eliminating some rows that it should not be eliminating.
The obvious way to solve this problem is to just bring the other column into the smaller table, but is there a way to just stop Power BI from deleting any rows that it sees as being duplicates? I know there is the Keep Duplicates button but I cannot figure out where in the query I should be putting it and which rows I should select to ensure that it prevents any duplicate rows from being deleted. Is there a way in Power Query to just prevent it from deleting any duplicate rows without having to select different columns?
