Refresh Failure

kiran123 · ‎10-10-2019

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 · ‎10-10-2019

@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.