SELECT Permission Denied Error 42000 at Process Step

Symptom

Error 42000 occurs at Process step, stating that the SELECT permission was denied.

Resolution

1. Open SQL Server Management Studio and connect to your SQL Server.

2. Right-click Logins and select New Login...

3. Go to the User Mapping page and make sure the SSAS SI is granted the role of db_datareader and dbo is specified under the Default Schema column of the target database.