Error 42000 occurs at Process step, stating that the SELECT permission was denied.
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.