Data source error The key didn't match any rows in the table.

[trevorG1]

Hi,

I have a report linked to an excel file on a SP site. It's be working fine all along. Now suddenly I'm getting the following error below.

I have had errors before where there has been a failed refresh due to a data mismatch due to someone changing a column name etc. but this time I can't seem to find any issues.

• Data source errorThe key didn't match any rows in the table.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

[Anonymous · Accepted solution]

Hi @trevorG1 ,

This error is often caused by the following three points.

• Mismatch between the data types of the keys used in relationships.
• Improper date formats of the date fields in relationships.
• (null) values in columns with decimal/whole number data types

For solutions to the above problems, you can refer to:

Power BI Error : “The exception was raised by IDataReader interface.”

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[trevorG1]

I usually get a differevnt error when that happens. Can't see any name changes in column headings or deletions 

[trevorG1]

I usually get a differevnt error when that happens. Can't see any name changes in column headings or deletions 

[atapbi]

@trevorG1 I have the same issue.
How did you fixed it ?

Thanks you

[amitchandak]

@trevorG1 , it is because a column missing at source or renamed as the source. try to address that

refer

https://community.powerbi.com/t5/Desktop/The-key-didn-t-match-any-rows-in-the-table-when-changing-da...

https://community.powerbi.com/t5/Service/SQL-Server-Change-Data-Source-gives-quot-Expression-Error-T...