Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
3 years ago
Solved

Dim Shows Cardinality As Many After Remove Duplicates

Hi all,   Using PBI Desktop. I imported a sheet from an Excel Workbook. I cleaned everything up including deleting duplicates on Group id to create a dim table.   I tried to join to a fact tabl...
Need Help
  • DeanWHall's avatar
    DeanWHall
    3 years ago

    If there are definately no duplicate keys in your join - are there any blank records that may be causing the link to turn into a M:M

tecumseh's avatar
tecumseh
Resolver III
3 years ago

Thanks Dean,

I added a Matrix and added the id to the Matrix.
The Null floated to the top.

I cannot see the null in the id field in PQ Editor: "Limit of 1000 rows reached"
I aaded a column to check the length of the item in the id field and received either 6 or null.

I filtered out the null.
Close/apply.

Now I am able to connect dim to fact.




 

Thanks,

-w