Please help -- Expression.Error: The key didn't match any of the rows in the table

[Anonymous]

Hi, I am getting an error in my PowerBI Desktop dashboard that reads "Expression.Error: The key didn't match any of the rows in the table."  There is an offline Excel file that is the source of the data driving this dashboard.  Recently changes were made to a few tab names within the Excel file, and a new tab was also added.  The source is linked correctly, but PowerBI is still giving me this error. Can somebody please help?  Thank you!

[v-jianpeng-msft]

Your solution is so great lbendlin ,thank you!

Hi, @Anonymous 

You seem to have gotten a solution. You can mark the replies that help you as solutions so that other members of the community can quickly find ideas to troubleshoot the problem if they encounter the same issue. Thank you for your cooperation.

Best Regards

Jianpeng Li

[Anonymous]

Thank you!!! I was able to figure it out after reading the link!

[lbendlin · Accepted solution]

Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power ...