I would suggest that you can set the time that an 'alerts' triggers. I have a job monitor dashboard with a number of completion percentage visuals. I would like to be able to fire an 'alerts' each morning at 8.30 for those which are not at 100%. I have tried using once every 24 hours but have no control over the time they 'alerts' executes. Looking forward to your response.
3 Comments
- My workaround was to create another measure in the tabular model which checked the percentage at 100% between certain times. If it was at under 100% then it would go to 1 causing the 'alerts' to fire at the correct time. Still would prefer flexibility within Power BI 'alerts' to set trigger time
- I created a workaround using 2 Flows: 1 to catch and cache 'alerts's in an excel table 2 to cycle through table at a specific time to generate emails (and perform other actions)
- Status added:Needs Votes
