Forum Discussion
Azure Analysis Services Can't Connect to On-Premises SQL Server using Data Gateway
Hello,
Here is my situation:
I have an Azure Analysis Services Tabular Model deployed and have configured an On-Premises Data Gateway to refresh the data from an on-premises SQL Server. Both the Tabular Model and the AS Model reside in the same region (North Central US) and are configured correctly (a green check mark is present) but I am receiving the following error:
The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_MashupDataAccessError
Received error payload from gateway service with ID 2912898: Async operation 1188e867-3bf0-4f6b-86d9-0163e645a004 is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessException: MashupException encountered while accessing the target data source.
GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
GatewayVersion=3000.40.15 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: InternalMashupException:<pi>Microsoft.Data.Mashup.InternalMashupException (0x80004005): We're sorry, an error occurred during evaluation. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> Microsoft.Mashup.Evaluator.Interface.ErrorException: The user name or password is incorrect.
---> System.Security.SecurityException: The user name or password is incorrect.
---> System.Security.SecurityException: The user name or password is incorrect.
at System.Security.Principal.WindowsIdentity.KerbS4ULogon(String upn, SafeAccessTokenHandle& safeTokenHandle)
at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName, String type)
at System.Security.Principal.WindowsIdentity..ctor(String sUserPrincipalName)
at Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(String username, String password, IEngineHost host, IResource resource)
at Microsoft.Mashup.Engine1.Runtime.CredentialExtensions.GetImpersonationWrapper(IResourceCredential credential, IEngineHost host, IResource resource)
at Microsoft.Mashup.Engine1.Library.Common.SqlResourceCredentialDispatcher.Apply(WindowsCredential credential)
at Microsoft.Mashup.Engine1.Library.Common.SqlResourceCredentialDispatcher.Apply(ResourceCredentialCollection credentials)
at Microsoft.Mashup.Engine1.Library.Common.ConnectionStringResourceCredentialDispatcher.ConstructConnectionString(String server, String database, ResourceCredentialCollection credentials, Nullable`1 connectionTimeout)
at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateConnectionInfo()
at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.get_ConnectionInfo()
My windows account that I am using to try to process the model has admin access to the backend database so that is not the issue. I am not sure what I am missing.
Any help would be greatly appreciated,
MGDev
2 Replies
- v-lili6-msft
Community Support
- GilbertQ
Super User
Hi there
Can you confirm that your data source in the On-Premise Gateway account being used can connect to the SQL Server Source?
Also to check that the details in your Connection are updated with the valid data source credentials?