Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Solved! Go to Solution.
Hi @Anonymous ,
“Regarding problem no. 3: found no duplicates in my table:”
Suppose you establish a 1:* relationship for two tables, then refresh the data and the table on the 1 side will be refreshed to contain duplicate data, then this type of error will occur.
So you need to check your data source. If the two tables in the data source have been updated to *:* relationship, then an error will be reported when you refresh.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
“Regarding problem no. 3: found no duplicates in my table:”
Suppose you establish a 1:* relationship for two tables, then refresh the data and the table on the 1 side will be refreshed to contain duplicate data, then this type of error will occur.
So you need to check your data source. If the two tables in the data source have been updated to *:* relationship, then an error will be reported when you refresh.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Has your problem been solved?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yes, thank you!
@Anonymous , refer these solition
https://community.powerbi.com/t5/Power-Query/Duplicate-Value/td-p/781471
How to debug error : https://www.youtube.com/watch?v=OE6DPmKqN7s
Intereting.. I only one active connection, which is Many to One. It used work fine..
Thank you, @amitchandak. Unfortunately those solution did not help much
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |