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.
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
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |