Fail to execute Semantic Model Validation step on Semantic Models based on Azure Analysis Services
Symptoms
When running a pipeline that includes steps of type Dataset (for example, performing checks such as Count Rows, Column Statistics, Dataset Values, or Duplicated Rows), the pipeline may fail with an error.
In the Pipeline logs, you might see a message stating:
“Failed to execute the DAX query.”
In the Pipeline logs, you might see a message stating:
“Failed to execute the DAX query.”
Cause
This issue typically occurs when your Dataset is configured in DirectQuery mode and connected to a data source hosted on Azure Analysis Services.
The most common scenario is when the semantic model you are currently testing is based on another semantic model.
When the platform attempts to run a test on a table from that base semantic model, the PowerBI API refuses to execute the query because it cannot directly access the underlying data.
When the platform attempts to run a test on a table from that base semantic model, the PowerBI API refuses to execute the query because it cannot directly access the underlying data.
To check whether your Dataset is based on another Dataset, use the Lineage view in Power BI. This will help you identify dependencies and confirm the correct source for your tests.
How to fix
To successfully run the test on the table, you need to execute the same step on the original Dataset or directly on the source data (e.g., the initial semantic model or another Analysis Services source).
Related Articles
How to configure Azure Storage for Wiiisdom Cloud Platform binary files
Overview This article explains how to configure a customer-managed Azure Storage Account to store binary files generated by Wiiisdom Cloud Platform. Warnings & Prerequisites You need permissions to create and configure an Azure Storage Account. ...Known Issues
Power BI Pipeline execution RLS with empty roles and simulation steps In Open Report and Simulation Journey steps, support for dataset chaining was introduced in version 1.18.0. This support requires us to perform additional checks on the dataset ...Choose Custom Storage in Wiiisdom Cloud Platform
Context When first connecting to the Wiiisdom Cloud Platform, you need to choose where to store your data. The only choice available are to either be hosted by Wiiisdom Azure Tenant, or your Azure tenant. We don't have access to other type of storage ...Datasource tables are not updated instantly
Summary Customers using Tableau Cloud environments may experience outdated metadata in in the table list for the Row Count, Column Statistics, and Datasource Values steps. This issue has been observed repeatedly, including on the new us-east-1 pod. ...WCP Cannot Create Workbook Version When First View Is Inaccessible
Summary When Wiiisdom Cloud Platform (WCP) attempts to create a version of a Tableau workbook, the process fails if the initiating user or service account does not have view permissions on the workbook’s first/default view. This issue occurs only ...