Forum Discussion

ChrisWeeks92's avatar
ChrisWeeks92
Helper I
7 years ago

live dataset issues for floorplan

Hi   I am trying to create a synoptic panel floor plan looking like this  My aim is to show the live status of the doors & windows.  It isnt quite working though.  It isnt pulling the latest r...
Need Help
ChrisWeeks92's avatar
ChrisWeeks92
Helper I
7 years ago

Hi v-yuta-msft  

 

My JSON connection is this

 

{
    "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

 

Does this help?

ChrisWeeks92's avatar
ChrisWeeks92
Helper I
7 years ago

Sorry to post again, but can anyone help me as i need to get this over to my boss by monday.  

 

Ultimately i am after the latest row only from each area2 and the status of whether they are open or not.  

 

I am using api/live data so i can only create measures.  

 

Any help is much appreciated