Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
suyogbi
Frequent Visitor

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

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

 

 

1 ACCEPTED SOLUTION
suyogbi
Frequent Visitor

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

}

}

View solution in original post

1 REPLY 1
suyogbi
Frequent Visitor

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

}

}

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.