Data Activator Power BI Report Alert Refresh Rate

Hello Anonymous 

I'll answer your 2nd question first: yes, Data Activator checks Power BI data hourly at present; we are looking to allow more frequent updates in a future release.

Regarding your 1st question: If your table has a timestamp column, then Data Activator will use the timestamp as the event time for each event. It will use that timestamp to remember which rows it has already seen, and then it will only look at new rows each time it polls the table. I can see from your screenshot that your table does indeed have a timestamp column, called "SubmissionDateTime", but it appears that Data Activator hasn't recognized it as a datetime column. Are you by any chance doing some string conversion on the column that is precluding Data Activator from recognising it as a datetime? If so, try removing the conversion and see if that fixes it.

Fixed it with this 

https://community.fabric.microsoft.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-savings/m-p/1086128/page/2