SSAS Tabular: ImpersonationMode that is not supported for processing operations I have a SQL 2016 SP1 SSAS Tabular Instance. I've deployed a model with the following properties





When I try to process the database or a table I get an error "The datasource contains an ImpersonationMode that is not supported for processing operations".

But if I change the impersonation info on the connection properties to use the service account instead of the current user it works fine.

We also don't get this issue if we change the Default Mode to DirectQuery instead of import, but we need to use Import because we need to use DAX username function for row level security.

I am an admin on the SSAS instance and also an admin on the SQL Server instance that is the data source. Why can't I process the SSAS tabular model as my user?
I agree the documentation on this is a bit terse, but the error message on the other hand is very clear. ImpersonateCurrentUser is not supported for models attached to a SSAS instance.

This is mentioned in the documentation of the ImpersonationMode Enumeration:


  ImpersonateCurrentUser: Not supported for tabular model databases attached to an Analysis Services instance. 


As well as in the documentation on Impersonation (SSAS Tabular) under the Options header:


  When configuring impersonation, or when editing properties for an
  existing data source connection in Analysis Services, you can specify
  one of the following options:
  
  
  ImpersonateWindowsUserAccount
  ImpersonateServiceAccount