Getting error when refreshing report in desktop DBCC Error in dataset refresh

[Anonymous]

Everything was working fine till yesterday and now I am getting the below error:

I checked sheet names and all and everything is fine. Anyone has a clue?

Thanks in advance!

[negi007 · Accepted solution]

@Anonymous this could be possible due to change in the column header in applied steps. To check the error, please go the first applied steps then go ahead one by one to check at which point you are geting the error. Then you will be able to identify the column which causing the error. I believe in your data, you are directly connecting to the DB so do not have control over the name of the columns.

[Anonymous]

I was not able to figure out which step created the problem and what chnaged in the data souce(other team members just play with the source). Finally, I deleted and imported athe source again.

[negi007]

@Anonymous Yes it happens many times with direct data sources. I hope your problem is resolved now. Thanks

[amitchandak]

@Anonymous , Refer if these old solutions can match

https://systemmanagement.ro/2018/05/18/power-bi-the-key-didnt-match-any-rows-in-the-table/

https://community.powerbi.com/t5/Power-Query/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/9824/page/2

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/m-p/155986