Forum Discussion
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.
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.
Hi
Are you sure for 1st question
Souds , there is no incremental EVALUATE() DAX query trigerring on Reflex .. based a datetime columns
Your need to manage depth of analysis , on the DAX measure
- All rows
- last non empty
- current hour
etc...