SSRS deployment error : Query execution failed for dataset…..(reErrorExecutionCommand)



Have you ever come across  Query execution failed for dataset…..(reErrorExecutionCommand) when you try to deploy a report in SSRS reporting server and when you run it? This error throws mainly because the dataset are not correctly set up during deployment. Best way to troubleshoot this is to edit in Report Builder and run the report. You will get the same error message but this design view help to troubleshoot problem easier. Go to dataset and check whether the connection type has been set to SQL Server and the connection string is correct. Test Connection button is helpful to test the connection. This error is common if you use more than one datasource in same report and setting up datasources correctly will resolve this error.