Power BI Rest API -- Datasets - Execute Queries-- Unbale to Execute query/Query Failing

[suyogbi]

Hi All,

i am trying to execute query using below API using try It window.

API Link: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries#code-try-0

API : POST https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/executeQueries

i have given Dataset id in Parameter part and in Body Part i am giving below query

{

"queries": [

{

"query": "EVALUATE (Filter (MyTable,MyTable[Column]="XYZ")"

}

],

"serializerSettings": {

"includeNulls": true

}

}

i am getting below error 

{

  "error": {

    "code": "BadRequest",

    "message": "Bad Request",

    "details": [

      {

        "message": "After parsing a value an unexpected character was encountered: 0. Path 'queries[0].query', line 4, position 82.",

        "target": "request.queries[0].query"

      },

      {

        "message": "'request' is a required parameter",

        "target": "request"

      }

    ]

  }

}

I checked query in DAX Studio and its running fine and giving the output but its failing when i embed that query in API.

Can You Please let me know what i am missing ?

Thanks In Advance

Suyog

[suyogbi · Accepted solution]

solved this. 

i was getting this error due to ".

we need to bypass " using /.

below is updated query we need to pass.

Query:

{

"queries": [

{

"query": "EVALUATE (Filter (MyTable,MyTable[Column]=/"XYZ/")"

}

],

"serializerSettings": {

"includeNulls": true

}

}