Forum Discussion
SQL Server Change Data Source gives "Expression.Error: The key didn't match any rows in the table."
We are migrating from SQL Server (version 11.0.7507.2) to SLQ Server (version 13.0.5865.1). Other than that all things remain the same, we tacke a backup of the old database and load that into the ne...
Found the culprit: the two missing SQL Table Functions did not have SELECT access granted. For some reason this was not an issue in the old version of SQL Server, but became an issue for the new version. So the newer version of SQL Server was deying access to the data becasue the access rights had not been granted.
A little bit late to the party but if someone is facing the same problem:
My problem was that the user we were using to connect did not have enough permissions to acces the tables used in the report. Once we granted sufficient permissiones, it worked well.