Error: The key didn't match any row in the table.

[Krishna09]

Hello Everyone,

I downloaded PBXI file from sharepoint. when I open power query and open sheets I have various error on each of the sheet in power query. Among them below one is one of them. Can any one guide me to solve this issue.

[vaibhavkale570 · Accepted solution]

you get this error when you change/delete the table ,column name etc or try to import the data that do not exist in the source.

if you're using import mode connection then you can see the already imported data  in Data view tab but maybe there is some change in the table at source level.

try to check the source setting in Applied steps.

[vaibhavkale570]

Seems like you're using the reference columns that have incorrect values.

[Krishna09]

But in Data section, I can see all values. they are correct.

[vaibhavkale570]

your provided reference image is not very much helpful, can't read the error messasge properly. can you be more specific about the error and type of data you're gandling.

[Krishna09]

The data source is sharepoint. I have downloaded PBIX file from sharepoint that is creatd by my collegue. 

Key is a column in the table reated by merging two columns . 

Error is the key didn't match any rows in the table. 

but in data section. I can view the table properly but when I open power query I see this error in few of the tables. I want to know the reason and solve it. 

Please let me know if more details are required. 

[vaibhavkale570 · Accepted solution]

you get this error when you change/delete the table ,column name etc or try to import the data that do not exist in the source.

if you're using import mode connection then you can see the already imported data  in Data view tab but maybe there is some change in the table at source level.

try to check the source setting in Applied steps.

[Krishna09]

The data source location was changed. now I donot have that error. but now I have error of column not found in table.

[vaibhavkale570 · Accepted solution]

columns that are used in appplied steps might be removed or renamed in your table. check the applied steps for removed or renamed columns. or they might have changed it at source level.