Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to create a relationship table between two large data sets. I have created a relationship table containing unique data, no blank rows and there are over 30,000 data entries. I am getting an error when trying to create the relationship in Power BI saying that I haven't removed duplicate values even though I have. Is this because the key table containing unique data is so large and can anyone offer a solution?
Many thanks
Solved! Go to Solution.
Check rows in the following calculated table.
Table = FILTER ( SUMMARIZECOLUMNS ( Table1[Column1], "Count", COUNTROWS ( Table1 ) ), [Count] > 1 )
First, you may select "Remove Duplicates" in Query Editor.
Second, check uppercase/lowercase spelling if it is a text field. Text(such as a, A) in query editor is case-sensitive, but not in the data model.
Finally, use SUMMARIZE Function and COUNT Function to have a check.
Thank you that has solved the problem for some duplicates.
I am still getting a problem with some data being duplicated even though I have formatted into lowercase - removed duplicates and uppercase - removed duplicates. Do you have any other suggestions as to the formatting issues that could be causing this?
Thank you
Check rows in the following calculated table.
Table = FILTER ( SUMMARIZECOLUMNS ( Table1[Column1], "Count", COUNTROWS ( Table1 ) ), [Count] > 1 )
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |