Forum Discussion

weiyu_chen's avatar
weiyu_chen
Frequent Visitor
4 years ago
Solved

What is the escape char for rest api execute queries in postman

POST Body: { "queries": [ {"query": "EVALUATE COUNTAX(FILTER('Activity',[Activity Status]=\"Completed\"), [Priority])" } ], "serializerSettings": { "includeNulls": true } }   Got this err...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi weiyu_chen ，

    I checked some of the relevant restrictions and it seems that none of them are touched on your side...

    1. Only 1 DAX query can be executed per REST API request.
    2. Each DAX query can have only 1 result set.
    3. Result sets are capped at 100k rows.
    4. Supported data types: string, numeric, boolean, blank, datetime and variant. Binary is not supported.
    5. Azure AS and SSAS do not support this DAX REST API.

    Is it possible that the error is reported because this DAX Query returned a single value, but the required return result here is a table? Change the DAX Query to the following form and see if it works:

    {
"query": "EVALUATE SUMMARIZE (
    'Activity',
    \"countofpriority\", COUNTAX ( FILTER ( 'Activity', [Activity Status] = \"Completed\" ), [Priority] )
)"
}

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi weiyu_chen ，

I checked some of the relevant restrictions and it seems that none of them are touched on your side...

  1. Only 1 DAX query can be executed per REST API request.
  2. Each DAX query can have only 1 result set.
  3. Result sets are capped at 100k rows.
  4. Supported data types: string, numeric, boolean, blank, datetime and variant. Binary is not supported.
  5. Azure AS and SSAS do not support this DAX REST API.

Is it possible that the error is reported because this DAX Query returned a single value, but the required return result here is a table? Change the DAX Query to the following form and see if it works:

{
"query": "EVALUATE SUMMARIZE (
    'Activity',
    \"countofpriority\", COUNTAX ( FILTER ( 'Activity', [Activity Status] = \"Completed\" ), [Priority] )
)"
}

Best Regards

weiyu_chen's avatar
weiyu_chen
Frequent Visitor
4 years ago

Anonymous Thanks a lot for the solution.