Data source contains an ImpersonationMode that is not supported for processing operations

Question

hi i am trying to connect the the data base using visual studo analysis service.

When i process the table i am getting this error:

"SSAS Tabular Project - Failed to save modifications to the server. Error returned: 'Data source contains an ImpersonationMode that is not supported for processing operations. A connection could not be made to the data source with the Name of 'SqlServe'"

Anyone have any idea how i can connect and process?

Answer 1

In Visual Studio for your Data Source in the General tab use "Windows Authentication", and in the "Impersonation Information" select "Use the service account".

Also in SSMS you need to add the login which SSAS runs under (default is NT Service\MSSQLServerOLAPService) to your regular SQL Server and give it permissions to all databases it will pull data from to create the cube. For me just "public" and "db datareader" was enough.