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.

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Deduplicate the SQL source in Power Query before you merge the sources. Better yet, don't merge them in Power Query. Let the data model do the work for you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for the Advice!

      Even when I merge data in powerquery I see that in data model relationship is different(done on its own).

       

      For now, I have filtered SQL table, so do not get duplicates so far. For future cases, look forward to find more optimal solution to deal with them.