Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to 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
}
}
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
}
}
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
User | Count |
---|---|
7 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
9 | |
2 | |
2 | |
2 | |
2 |