Hello, probably there was some confusion with user credentials. I was truing to process the model from third machine. While doing it from Gateway machine, then everything works.
Thank you for hint!
Fred
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I try to connect Azure Analysis Services Tabular model to the On-Premise SQL server database Through Azure On Premise Data gateway.
Data gateway is connected to analysis services and is shoving green light. SQL Connection succeeds from Azure Analyses Services using SSMS.
However trying to process Azure Analysis Services tabular database results with 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_DataSourceAccessError
Googeling this error it appears that impersonation mode “Use the service account” should be right choice - https://community.powerbi.com/t5/Power-Query/Tabular-model-process-failed-with-DM-GWPipeline-Gateway/td-p/230245
Where to find what Account is used as service account for Azure Analysis Services and how to change it?
Similar question unfortunately without answer can be found also here: https://social.msdn.microsoft.com/Forums/en-US/1f7392dc-6c78-41c4-a189-fcbe75b4681b/impersonate-service-account?forum=AzureAnalysisServices
Regards,
Hello, probably there was some confusion with user credentials. I was truing to process the model from third machine. While doing it from Gateway machine, then everything works.
Thank you for hint!
Fred