Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Disabling Dublicate notification

Hello all, I have prepared the powerbi file where I get data from SharePoint and SQL server. Tables have been merged based on 3 different columns.  I use this powerbi file on different projects. (...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

Can you please show the duplicate notification you received? Do you have any transformation or data modeling operation which requires a unique column in the table? Usually when a column is on the one-side of a relationship, it will pop up error message when applying data to the model if this column has duplicated values. 

 

Best Regards,
Community Support Team _ Jing

Anonymous's avatar
Anonymous
Not applicable
4 years ago

.In powerbi file, i get data from 2 sources( Sharepoint and SQL server).

I have merged tables from both sources in powerquery.  Merging done by unique column. However, there are sometimes duplicates in the column from the SQL server.

 

The question is that, even if there are duplicates, is it possible to avoid notification(error which says there is a duplicate) and run the query.