Configure Alerts from GPS data in PBi and Power automate

[Tejinder]

I have a data source that provides me LAT and LON of drivers if they are active and the last time they were active, I want to set some sort of automated alerts if drivers are not active by a certain time, for example, if a Driver's location has not been updated before 6:00 AM, I would like to send an Alert, (Teams msg or email)

I am thinking of using Power Bi Alerts and Power Automate flows for this, The Idea is to calculate the time duration difference in the Latest GPS time and Expected check-in time, and if the difference is negative an alert triggers the flow

The reason I am doing this in PBI is because I already have a report setup from this data.

Will this work and is there a better way to set it up somewhere else other than Pbi?

[amitchandak]

@Tejinder , You can explore Data Activator which part of Fabric and If you using the Farbric Trail or Activator trail, you should get it

https://learn.microsoft.com/en-us/fabric/data-activator/data-activator-get-started

Power Automate is another option which you can use

https://powerautomate.microsoft.com/en-us/blog/trigger-flows-from-power-bi-reports/

https://learn.microsoft.com/en-us/power-automate/trigger-flow-powerbi-report