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.
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 )
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 |
---|---|
112 | |
97 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |