Forum Discussion
Error when changing SP Source url and Apply queries
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
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
1 Reply
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