Forum Discussion
suyogbi
4 years agoFrequent 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://...
- 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
}
}
suyogbi
4 years agoFrequent 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
}
}