Able to deploy but unable to process the AS tabular model on Azure Analysis service

Question

Able to deploy but unable to process the AS tabular model on Azure Analysis service .

New AS service provisioned in Azure with the below compatibility

I get the below error from VISUAL STUDIO

Error message

------ Build started: Project: TabularModel, Configuration: Development x86 ------
------ Deploy started: Project: TabularModel, Configuration: Development x86 ------
Cannot process database. Reason: Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_InvalidConnectionCredentials
Received error payload from gateway service with ID 1179216: Async operation 2dee097d-a3f2-4f1c-8a28-d71eadccc7df is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Missing or invalid credentials for data source. Reason = '<pi>AccessUnauthorized</pi>', DataSource = '<pi><pi>SQL/XXXXX;######</pi></pi>', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin
= ''.

DataSourceReferenceOrigin= --->
1Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupCredentialException:<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The credentials provided for the SQL source are invalid

What should we be doing to fix this issue?

Answer 1

Resolved it by setting up the right service account in Gateway