Ole db or odbc error the key didn't match any rows in the table power bi

[Anonymous]

Hello everyone,

So im getting this error after trying to refresh my power bi dashboard, i've read that it maybe because a sheet name was changed in the data source (using Excel in a Sharepoint)  but no sheet name was changed. The file was not moved to another location either.

[MYOMYO15]

hello ,  I'm new member of Power BI. Now I'm facing error : Ole db or odbc error the key didn't match any rows in the table power bi. so tell me pls  how to fix that one.

[v-janeyg-msft]

Hi, @Anonymous 

Generally speaking, it may be due to changes in your table name or column name. You need to check it carefully and make sure there are no leading or trailing spaces in all names.

Reference:Solved: The key didn't match any rows in the table - Microsoft Power BI Community

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[amitchandak]

@Anonymous , Open power query and check for error

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs