December 11, 2017 at 10:22 am
Deleted.
December 11, 2017 at 10:29 am
You are getting the error because there is no way for the SSAS instance to communicate with your local database in order to refresh the data.
You need to install and configure an on-premises data gateway. More info here: https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway
December 14, 2017 at 10:05 am
Deleted.
December 14, 2017 at 10:27 am
Sorry, my bad...thought that you meant an SSAS instance in the cloud when you said "remote". Assumptions...
Definitely looks like a security/permissions error. When you execute it locally, it runs within the context of your user account. When running from the server (or deployed SSIS package) however, the user context under which it is running probably does not have permissions to the source database. Edit the connection properties within the deployed version on your remote SSAS instance. Make sure you impersonate and try different options (windows and sql accounts) to see if that brings you any closer.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply