Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
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
Deleting the table and readding it did the trick, thanks for the suggestion!
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |