The key didn't match any rows in the table. Details. Trying to change the table schema.

[raduser]

Hi,

I am trying to change the schema of a table object by going to the advanced editor but it keeps on erroring out. The contents of the advanced editor:

let
Source = Sql.Database(ServerName, DatabaseName),
dbo_Table_Name = Source{[Schema="dbo",Item="TableName"]}[Data],
#"Renamed Columns" = Table.RenameColumns(dbo_Table_Name,{{"customer_id", "CustomerID"}})
in
#"Renamed Columns"

All i want to change is the Schema of the object from "dbo" to "data". The new table in the new schema does have a new column. Is that the problem?

The changing of the schema unfortunately keeps on failing. Is this an easy thing to solve?

The error I get is the below:

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Schema=data
Item=TableName
Table=[Table]

Thanks,

[PhilipTreacy]

@raduser 

Do you have a table called TableName in the database?

Phil