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

Mudassar A 491 Reputation points
2021-01-25T17:51:35.11+00:00

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

60353-image.png

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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
458 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Mudassar A 491 Reputation points
    2021-01-25T20:05:45.66+00:00

    Resolved it by setting up the right service account in Gateway

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.