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.