Error when changing SP Source url and Apply queries

[mariaLP1610]

i have been trying to create a copy of a report and change the SP site url so it gets data from the DEV site.

i am getting the following error:

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

Id = 

Table=[Table]

the list in the development has data. i cannot seem to understand what causes the issue and debug more

[mariaLP1610 · Accepted solution]

well, seems like after i replaced the source url , tables kept guids from the production environmet.

i switched it with the Title column instead of Id and seems to work. however other errors occure as well in a tables renamed columns.

Not sure is from edit queries, switching List guid with List Title is the best approach