Forum Discussion
Data Activator Power BI Report Alert Refresh Rate
Community AdminHello 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.
Hi James,
I have fixed the issue with the datetime not being recognised properly but now when it is recognised, data activator interprets it as UTC time when the time is actually in AEST. Is it a bug that its not recognising it properly?
Because this is being recognised incorrectly if something had a time stamp at 12pm AEST(2amUTC) , it will think its 12pm UTC and then you basically have to wait till the actual 12pmUTC time which is a 10hour delay AEST before it triggers.