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

[Gandhia]

Good morning everyone,

I have a problem with few reports: Expression.Error: The key didn't match any rows in the table.

And I know the error occurs because there is some "Removed Coloumns" and/or "Removed Other Columns" and/or "Renamed columns" (can see them in desktop --> Transform data) (+ in some reports there are a lot of other changes, too. For example "Added column", "Removed Duplicates", "ExpandTableColumn", "Nested Join" etcetc. 
So the problem is: datasets don't refresh because there have done changes in data source. Dataflows works now, but datasets need changes that they would refresh again. 

For example when there is Renamed Columns in applied steps, I can see what columns have changed, and what they were before change and what they are now. But I don't know and cant solve this issue: HOW can I get over this error? I can't go to the data source and change them, so I need to do it in Power Query I think.

And in Power bi Service there are a refresh errors in datasets. (The 'Column X' column does not exist in the rowset) and the other "The column 'Column X' of the table wasn't found... ... The exception was raised by the IDbCommand interface. Table: [Table's name]

Does anyone have any ideas or solution for this annoying problem? Faster the better. 🙂

Thank you in advance!

[ryan_mayu]

@Gandhia 

if the column name changed, you can go to advanced editor to do the corresponding change.

[Gandhia]

Thanks for the answer. Yes, but how I should do it in concrete terms? In advanced editor it looks like I don't need to do corresponding changes; For example there is already "Table.RenamedColumn(#"Changes type",{{"ID", "Company_ID"}, "CurrentYearToday", "Year"}, {"OrganizationID", "CompanyID"}...

So what should I do? If the Power Query knows those changes etc., why there is still error? And what should I do that I can solve this problem? I don't understand it 😕

[ryan_mayu]

could you pls share the pbix file? the error may cause by different reasons. 

[Gandhia]

Unfortunately it is not possible, which make this more difficult.