I'm creating a tabular model which contains some direct connection, and one legacy (table using this connection is a simple SQL Query)
when providing the username for impersonation (using a dedicated account that have access to databases), the validation works fine for all kind of datasources.
But when I deploy I receive an error message "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Login failed for user 'domain\specialaccount'.; 28000."
what is strange is that the same account works fine for the non-legacy datasource..
any idea ?