Error processing data in dataset - The key didn't match any rows in the table
Hi I have created a report that joins two sql server views in a 1:Many relationship with one view containing the supervisors and the the other their trainees. Ths is the relationship: It all works fine in the desktop app and I can refresh the datasets there no problem, however when I try to refresh the semantic model in the web version I get the error message below: I have searched the "The key didn't match any rows in the table" part of the message extensively and it usually applies to excel sourced datasets where one of the column names has changed. This is not the case here. I have also confirmed that there are no IDs in the child view (vwPowerBi_SupervisorTrainees) that do not exist in the parent view. Any help\ideas would be much appreciated. Regards David
