0

I'm automating PowerBI API requests in Tosca. The query I want to execute as payload of a Postrequest is working fine in Postman and also in the API scan module of Tosca but when exporting the API scan to ToscaCommander and implementing the module in a testcase I have problems with how Tosca is evaluating the DAX query.

The query is the following:

EVALUATE{CALCULATE(COUNTROWS('InfM_CommonInsurance dimQuotation'),FILTER('InfM_CommonInsurance dimQuotation','InfM_CommonInsurance dimQuotation'[Quotation_Date] >= DATE(2025,5,1) && 'InfM_CommonInsurance dimQuotation'[Quotation_Date] <= DATE(2025,5,31)))}

The error thrown when running the Testcase is:Token is not valid in this context: >= DATE(2025,5,1) && 'InfM_CommonInsurance dimQuotation'

I tried to surround the query with single or double quotes with no positive result.

Improve this question
Related questions
0
Tosca run Testcase for every row in TDS/TDM
0
Power BI - DAX - ADDCOLUMNS - Syntax Error - Invalid token, Line 3, Offset 2,
58
What's the difference between DAX and Power Query (or M)?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.