Forum Discussion

suyogbi's avatar
suyogbi
Frequent Visitor
4 years ago
Solved

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://...
  • suyogbi's avatar
    4 years ago

    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

    }

    }