IssueWhen authenticating using the Run As account, the following error message is received after refreshing a published data extract:
[Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object '<OBJECTNAME>',
database '<DATEBASENAME>', scheme 'SCHEMATYPE'
The table "[<SCHEMATYPE>].[<OBJECTNAME>]" does not exist.
Unable to connect to server "<SERVERNAME>". Check that the server is running and that you have access privileges to the requested