live dataset issues for floorplan

Question

Hi&nbsp;I am trying to create a synoptic panel floor plan looking like this&nbsp;My aim is to show the live status of the doors &amp; windows.&nbsp; It isnt quite working though.&nbsp; It isnt pulling the latest row through to the panel.&nbsp;&nbsp;My data looks something like this;&nbsp;The closed column is a measure with the following DAXclosed = IF(CONTAINS(RealTimeData,RealTimeData[state],"NOT_PRESENT"),0,1)and Last Closed State is another measure which isnt working correctly though.&nbsp; This has the following DAXLastClosedState = 
IF ( 
    HASONEVALUE ( RealTimeData[area2]),
    VAR LastTime = MAXA(RealTimeData[createTime])
    VAR Result = CALCULATE (RealTimeData[closed] , RealTimeData[createTime] = LastTime )
    RETURN Result
)My dataset is being inserted from MS-Flow via an API.&nbsp; when a door or window opens or closes it inserts another row with the current status and this is what i want the synoptic panel visual to view and not the previous rows in the dataset.&nbsp;&nbsp;&nbsp;I have a deadline for this friday to get it working and for the panel to be updating when someone opens/closes the window or door.&nbsp; I hope someone is able to guide me in the right direction and get the floorplan working correctly.&nbsp;

v-yuta-msft · Answer

Hi ChrisWeeks92,
&nbsp;
For further analysis, could you share your connection string or rest api connection details in your power query code?&nbsp;
&nbsp;
Regards,
Jimmy Tao

chrisweeks92 · Answer

Hi&nbsp;v-yuta-msft&nbsp;&nbsp;&nbsp;My JSON connection is this&nbsp;{
    "type": "object",
    "properties": {
        "event": {
            "type": "object",
            "properties": {
                "eventId": {
                    "type": "string"
                },
                "targetName": {
                    "type": "string"
                },
                "eventType": {
                    "type": "string"
                },
                "data": {
                    "type": "object",
                    "properties": {
                        "temperature": {
                            "type": "object",
                            "properties": {
                                "value": {
                                    "type": "integer"
                                },
                                "updateTime": {
                                    "type": "string"
                                }
                            }
                        },
                        "touch": {
                            "type": "object",
                            "properties": {
                                "updateTime": {
                                    "type": "string"
                                }
                            }
                        },
                        "objectPresent": {
                            "type": "object",
                            "properties": {
                                "state": {
                                    "type": "string"
                                },
                                "updateTime": {
                                    "type": "string"
                                }
                            }
                        }
                    }
                },
                "timestamp": {
                    "type": "string"
                }
            }
        },
        "labels": {
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "area": {
                    "type": "string"
                },
                "area2": {
                    "type": "string"
                }
            }
        }
    }
}and the data is being pushed to the flow url which is then being added into the live Power BI dataset&nbsp;Does this help?