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 the 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 the dbo is specified as Default Schema on the target database.