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.” 

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. 

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

• Issue regarding Power BI Slicers

  Context On the Wiiisdom Cloud Platform, you can simulate their journey by selecting slicers and specifying the values they want to apply. However, under certain conditions, slicers may not behave as expected. Instead of applying the selected value, ...

• 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 instantanely

  Summary In the Wiiisdom Cloud Platform, outdated data appearing in the table list for the Row Count, Column Statistics, and Datasource Values steps. This behavior affects customers who use Tableau Cloud. This happens because the tableau internal ...

• 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 ...

• Unable to set the "Exclude Null Values" option for filters

  Known Issue Date filter configuration is not able to exclude null values when executed through the filter simulation method, leading to mismatched results compared to the dashboard behavior. Summary When using Tableau’s method to simulate dashboard ...