Forum Discussion
Solved
Getting Expression.Error: after removing 3 columns from excel data source
I have had to do two changes to my PowerBI reports im working on that are causing errors. Expression.Error: The key didn't match any rows in the table. Details: Key= Item=Table1 Kind=Table T...
I figured out the problem. Previous versions of excel sheet were being imported as a table. The excel sheet had been converted to a table prior to being prepared as a data source.
That is why I was getting key row errors and table1 errors.
Ctrl + A on entire Excel spreadsheet, convert to table. Save spreadsheet.
