REST API ExecuteQueries

Anonymous — Fri, 17 Jun 2022 08:45:41 GMT

Hi ...I am new to BI & DAX . Please help me to have a better understanding. I have the a data table (given above) from which I should retreive the latest single record based on SensorId through API's. The POST ExecuteQuery API with below body gives me a list of values. How can I get only a single latest record ? TIA
"queries": [
{
"query": "EVALUATE FILTER(ALL(usecase[Time],usecase[Telemetry],usecase[SensorName],usecase[SensorType],usecase[SensorID]),usecase[SensorID] = 475601) ORDER BY usecase[Time] desc"
}
],
"serializerSettings": {
"includeNulls": true
}
}

amitchandak tamerj1 SpartaBI

Re: REST API ExecuteQueries

ValtteriN — Fri, 17 Jun 2022 07:02:40 GMT

Hi Anonymous ,

If you want to get only the latest value you can use TOPN in your query
e.g.
EVALUATE TOPN(1,FILTER(ALL(usecase[Time],usecase[Telemetry],usecase[SensorName],usecase[SensorType],usecase[SensorID]),usecase[SensorID] = 475601) ORDER BY usecase[Time] desc)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

topic Re: REST API ExecuteQueries in DAX Commands and Tips

REST API ExecuteQueries

Re: REST API ExecuteQueries