Forum Discussion
One-to-Many Relationship with Unique Values Not Working
So, I've two tables (Excel Files) named 'Item Master' and 'Milestones'. Item Master has roughly 15 columns with a column named "Part Number". Milestone also has a column named "Part Number". ...
Greetings from New Zealand,
I just had the same issue and couldn't find any duplicates, nor null values in my Excel file.
However after importing my Excel file into Power BI I noticed that Power BI had imported two more rows at the end than I expected from my Excel file and thus created Null value rows.
It turns out that Power BI can import additional Null value rows from Excel.
The safe solution to prevent this is
to change the data in Excel into an EXCEL-TABLE first (mark the range > Insert > Table)
then import it to Power BI
This way no more null rows are created and the relationship 1:Many is possible.