Power BI Desktop - Create Relationship cardinality error

[Marklarbear]

Hi team, I'm a long time excel user (i would say i'm intermediate to advance in excel knowledge) - however i'm starting my journey with Power BI Desktop.

When i try to create a relationship between 2 'tables' using the column 'Month' i get the following error and i have no idea how to fix it???

Error: The cardinality you selected isn't valid for this relationship.

The only thing i can see (in my very very limited experience with power bi desktop) is that the data in the table with the 'many' information (which has been brought in using power query and transformed) seems to be blank - however if i select the column it shows data there?????

again - being a noob to power BI desktop..... any help will be greatly appreciated

 

[RoryA]

It looks like you have a blank row in the first table - you can't have that in the table on the 1 side.

 

[Marklarbear]

It looks like you have a blank row in the first table - you can't have that in the table on the 1 side.

brilliant - that was it.... i've inserted a new step now to remove blank rows before i 'close & load' cheers heaps for your assistance

 

[RoryA]

Glad we could help.