Current temperature from Azure stream

AlexZhidkov — Mon, 24 Sep 2018 10:10:53 GMT

I need to display current (last reading) from a connected temperature sensor. Data from the sensor is sent to Azure IoT Hub once every minute. Stream Analytics job outputs it into Power BI sink. This is JSON data the sensor sends:

{
    "temp": "22.88",
    "name": "POC",
    "id": "232053ab5ba5ceee",
    "time": "2018-09-23 07:09:06",
    "agentid": "ZRQOfcbeFBHk"
}

That's what PowerBI receives:

[
    {
        "temp": "AAAAA555555",
        "name": "AAAAA555555",
        "id": "AAAAA555555",
        "time": "AAAAA555555",
        "agentid": "AAAAA555555",
        "EventProcessedUtcTime": "2018-09-23T07:22:56.643Z",
        "PartitionId": 98.6,
        "EventEnqueuedUtcTime": "2018-09-23T07:22:56.643Z",
        "IoTHub": "AAAAA555555"
    }
]

What is PartitionId and how do I display just the latest reading (current temperature) only?

topic Current temperature from Azure stream in Developer

Current temperature from Azure stream