Date table join error during refresh: The key didn't match any rows in the table

[Anonymous]

I've added a new table to my datamodel which links to a simple excel file that lists dates from 2/1/20 to 7/1/20 and another column with data. I've joined this table to my date table in my data model. When I click on refresh in PowerBI desk top I get a refresh error that the load was cancelled because of an error in the table that I added. The error I get is "The key didn't match any rows int he table."

My date table goes from 1/1/20 thru 1/1/2030...do both tables need to have the same date range? I feel like it might be a join error but I'm not sure? See two screen shots below.

 

[Abduvali]

Hi @Anonymous,

Not sure about your dates format in SIOP table =o?

SIOP date format is dispalys 05/01/20? and Dates table has it as 01/01/2000

Just make sure your dates are in identical format and then join, it should work as guys mentioned already.

Regards

Abduvali

[amitchandak · Accepted solution]

From date to table make it many to one and try load again.  or try once by disconnecting the join and once data is loaded join again. It should take correct join

[Anonymous]

Deleting the table and readding it did the trick, thanks for the suggestion!

[Greg_Deckler]

In your first picture it shows 1:1 so yes, those all need to match I believe. So make it 1 to many or many to 1?