Strange. You should be able to use the service account impersonation setting. It's what we use here at the current project.
Make sure the SSAS service account has read permissions on the SQL Server database.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP