Forum Discussion
Relationship (Strange behavior)
Hi there, I came across a weird behavior into PBi today. I tried to create a relationship between two tables using the email field, on the table view_leads the email is unique but on the table sc...
amitchandak
Super User
Super UserAnonymous , view_lead does not have unique email or have blank record for email. Check for these 2 first
Yes, I found a few blank records for email. Is there any way to omit this blank records in order to create that relationship?
PaulDBrownCommunity Champion
You can filter out the blanks in Power Query. However, that would potentially leave out rows and leave orphaned records when you use the dimension table. One way of avoiding this is to create an ID column, for example by concatenating name with email. Or creating a fake email for blank values as an ID
It didn't work.
mattwwResponsive Resident
This happens to me all the time, null emails causing a many-to-many