ASS tabular models Deployment failure in dev enironment which is successful in devlab

Nagati PraveenKumar 1 Reputation point
2022-03-12T14:54:52.793+00:00

PraveenNagati-9397 asked • 21 hours agoActions
ASS tabular Deployment failure
Hi All,

We have an issue while deploying tabular models to another environment. earlier it worked and we faced an error like below, it is showing a different table for when tried to execute deployment multiple times. we have cross-checked with deploy to another environment give successful build but it's failed in an actual environment which we need to deploy.

[error]Error during executing queries (Execute TMSL against 'asazure://asazure.windows.net/asdneubisdev' complete with errors.

The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: 'Expression.Error: The key didn't match any rows in the table.. Key = <pii>[Schema = "Finance_RevIc_dtm", Item = "vw_Site"]</pii>. Table = <pii>#table({"Name", "Data", "Schema", "Item", "Kind"}, {})</pii>. ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface.
Expression.Error: The key didn't match any rows in the table.. Key = <pii>[Schema = "Finance_Rev3rd_dtm", Item = "vw_Customer"]</pii>. Table = <pii>#table({"Name", "Data", "Schema", "Item", "Kind"}, {})</pii>. ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface.
The command has been canceled.. The exception was raised by the IDbCommand interface.

Can you Please Help Me on this.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
458 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,290 questions
{count} votes

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.