Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
18 | |
17 | |
16 | |
8 |