Refresh Failure

[kiran123]

Hi Team,

we have created the custome table and getting the data from sql server from multiple table as we  have made some modification in the tables for removing the duplicate values its worked at first time but after refreshing the data on second time 

in sql table we get the duplicate values but in power bi though i have added custome filter for removing the duplicate values.

but its not working for second time for the refresh.

Its showing error.

Duplicates are not allowed in many to one relationship or for columns that are used as the primary key for the table

[Anonymous]

@kiran123  I usually just trouble shoot this in the report. Drop the field in a table, drop it in again and change it to Count. sort by the count. It will show any duplicates. Sometimes this also results with blanks being in your id row.