Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I expect to have new events throughout the day without gaps without data, I know that I do not stop receiving data throughout the day seeing my query that works in near real time, at some point during the day I stop having new events, maybe it is because the semantic model of my report needs to be constantly updated?, as far as i calculated, they are less than 1 events per second, if you know another reason for this let me know,
Also there's another 2 curious things, i have a trigger to send me a mail when no new data is received, its not working tho... and about my other triggers, they send batches of mails at once instead every time the condition 'becomes greather than or equal' is met, for example, i have event A at 16h00m and event B at 16h45m, instead i recieve 2 mails nearly after the trigger is activatted i get the 2 mails at 17h00m, now imagine this with 30 mails (already happened), instead of being helpful it becomes spam, how can i solve this?
Thanks for reading!
Solved! Go to Solution.
@jameshutton
"Data Activator checks your model once per hour...", "This will happen even if your model never refreshes." This can be customized?
I've stopped receiving new data for 5H, so maybe "Data Activator is no longer able to connect to your model." is the issue, i haven't receieved any mail from Data Activator tho.
What worked for me is using power automator to refresh the report every 1 hour, it's been working like this for 4 hours and the problem I had is gone.
I change some conditions in my triggers after clearing cache because each trigger appears as 'Untitled', this works for now thanks
I'm also seeing the behaviour that the semantic model (Direct lake) needs to be refreshed in order to get alerts.
Events are registered every hour. But Data Activator doesn't detect changes unless I refresh the direct lake semantic model. The events just log the same value every hour, unless I refresh the direct lake semantic model.
The direct lake semantic model has "Keep your Direct Lake data up to date" (Automatic refresh) turned on. There are data changes in the report several times each hour. So the issue is not with the model or report.
But Data Activator for some reason only detects the changes after I refresh the direct lake semantic model. I think it is a bug.
@jameshutton
"Data Activator checks your model once per hour...", "This will happen even if your model never refreshes." This can be customized?
I've stopped receiving new data for 5H, so maybe "Data Activator is no longer able to connect to your model." is the issue, i haven't receieved any mail from Data Activator tho.
What worked for me is using power automator to refresh the report every 1 hour, it's been working like this for 4 hours and the problem I had is gone.
I change some conditions in my triggers after clearing cache because each trigger appears as 'Untitled', this works for now thanks
Hi @Anonymous , at present you can't customize how often Data Activator checks. As a roadmap item, we intend to make Data Activator perform the check whenever the model refreshes for import-mode datasets, and to make it customizable for direct mode/directlake models.
hi @jameshutton I have a similar problem (posted here https://community.fabric.microsoft.com/t5/Activator/Adjusting-Data-Activator-Trigger-Frequency/m-p/4... )
Currently, my trigger is configured to send hourly messages via Teams (because of this hourly query), which ends up being too frequent for my needs. Ideally, I would like the messages to be sent weekly instead.
What would be a feasible solution to adjust the trigger frequency in this case? Any advice or guidance would be greatly appreciated.
Thank you!
Hi,
any update on when it will be available that Data Activator can check a model when it was refreshed? I.e. we want to check for KPIs when the Purview Hub Semantic Model was refreshed...
Thanks,
Thomas
Hey @jameshutton , I am looking forward to having data activator to check whenever the model refreshes. Right now it's a pain the neck, right now does it check when you create a trigger right? I have 5 different objects with a reflex and each of them checks at the different time.
Hello @Anonymous , no, you do not need to refresh your semantic model in order for new events to arrive. While your trigger is running, Data Activator checks your model once per hour and generates an event based on the data that's in your model at the time it performs the check. This will happen even if your model never refreshes. The behaviour you are seeing suggests one of two things:
1) You have stopped your trigger, OR
2) Data Activator is no longer able to connect to your model.
You can check for 1) by checking whether your trigger is shown as running in DA, as indicated by the fact that the "Stop" button is enabled for the trigger.
If 1) is not the cause, then Data Activator has encountered an error. Data Activator should mail you about the error per this page: https://aka.ms/dataActivatorErrors. Please check whether you have received an email from Data Activator with one of these errors. If not, then the only workaround I can suggest at this time is to re-create your trigger. If the problem keeps happening, please let us know,
Hi @Anonymous ,
According to your description, here are my steps you can follow as a solution.
1.Use the "Send me a test alert" option to verify the trigger's functionality. If it's not working as expected, reviewing the conditions and actions set for the trigger might be necessary.
2.Consider external factors such as email server settings or spam filters that might delay or batch your emails. Adjusting these settings might help achieve more immediate email notifications.
3.Try to delete your reflex and recreate it.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.