Skip to main content

Power BI

New

Service Alerts

Vote (10) Share
williamsjd's profile image

williamsjd on 14 Sep 2016 23:28:25

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.

Comments (2)
williamsjd's profile image Profile Picture

91f9a980 0319-4cd9-b86d-cfa2f970c2ca on 05 Jul 2020 22:42:16

RE: Service Alerts

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)

williamsjd's profile image Profile Picture

e92c1925 103d-401e-8028-3c8573130b62 on 05 Jul 2020 22:31:18

RE: Service Alerts

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