Forum Discussion
ChrisWeeks92
Helper I
8 years agolive 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...
v-yuta-msft
Community Support
8 years agoHi ChrisWeeks92,
For further analysis, could you share your connection string or rest api connection details in your power query code?
Regards,
Jimmy Tao
- ChrisWeeks928 years ago
Helper I
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?
- ChrisWeeks928 years ago
Helper I
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