Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ChrisWeeks92
Helper I
Helper I

live dataset issues for floorplan

Hi

 

I am trying to create a synoptic panel floor plan looking like this floorplan with colours.JPG

My aim is to show the live status of the doors & windows.  It isnt quite working though.  It isnt pulling the latest row through to the panel.  

My data looks something like this;

door status data.JPG

 

The closed column is a measure with the following DAX

closed = IF(CONTAINS(RealTimeData,RealTimeData[state],"NOT_PRESENT"),0,1)

and Last Closed State is another measure which isnt working correctly though.  This has the following DAX

LastClosedState = 
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.  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.  

 

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.  I hope someone is able to guide me in the right direction and get the floorplan working correctly. 

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

Hi ChrisWeeks92,

 

For further analysis, could you share your connection string or rest api connection details in your power query code? 

 

Regards,

Jimmy Tao

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?

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.