Forum Discussion
Error processing data in dataset - The key didn't match any rows in the table
Hi, David111
I found some links and hope it helps:
Solved: Expression Error.: The key didn't match any rows i... - Microsoft Fabric Community
Solved: Expression.Error: The key didn't match any rows in... - Microsoft Fabric Community
This could also be an issue with the new version. It can have a problem with text format conversion, the previous CSV file extracted to PBI line breaks will be converted to spaces, and now the line breaks will become line breaks. You need to check if there is any problem with the steps of your PowerQuery format conversion. It's also possible that there is an internal service issue, which the team is currently following up.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thanks heaps for the response. I checked the datatypes and one was varchar(10) and the other nvarchar(20), so I tried casting them both as varchar(10), but it made no difference. I even tried casting them both as ints. I also confirmed there are no null values returned for these fields in either view.
It is definitely this join causing the issue. When I remove the vwPowerBI_SupervisorTrainees view from the report, I am able to refresh the dataset (but don't have the information I need).
Regards
David
Hi, David111
I found some links and hope it helps:
Solved: Expression Error.: The key didn't match any rows i... - Microsoft Fabric Community
Solved: Expression.Error: The key didn't match any rows in... - Microsoft Fabric Community
This could also be an issue with the new version. It can have a problem with text format conversion, the previous CSV file extracted to PBI line breaks will be converted to spaces, and now the line breaks will become line breaks. You need to check if there is any problem with the steps of your PowerQuery format conversion. It's also possible that there is an internal service issue, which the team is currently following up.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It was a permissions issue to the view vwPowerBI_SupervisorTrainees.
Thanks, that second link tipped me off.
Regards
David