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

suyogbi — Tue, 21 Sep 2021 07:52:44 GMT

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

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

suyogbi — Wed, 22 Sep 2021 06:11:35 GMT

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

}

topic Re: Power BI Rest API -- Datasets - Execute Queries-- Unbale to Execute query/Query Failing in Developer

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

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