I am running the Dimension health Check Report and I get this error:
Query execution failed for dataset 'DimensionHealthCheckResults'.
Execution of the managed stored procedure ListDimensionErrors failed with the following error: Exception has been thrown by the target of an invocation.Could not open connection to data source DBWarehouse. Because the password for a SQL security connection
cannot be retreived from SSAS, they are not supported. Register this assembly with impersonation settings which have access to connect to the data source using Integrated Security. Exception was: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I tried setting the Assembly impersonation to every available setting and no go.
This points to our warehouse relational DB, and we use Windows Integrated Security, so not sure if that has anything to so with it.
I'd rather not have to change any major security settings to make this work.