Forum Discussion
Helper IEmail Notifications from a Dashboard
Hi everyone,
I hope someone can help and assist with my query.
I have a dashboard that refreshes daily in a Power BI workspace. This dashboard contains a list of outstanding cases, and each of these case has an escalation level of "routine", "bronze", "silver" and "gold".
What I want to happen is as follows:
- Dashboard refreshes
- If there are any new cases assigned with the gold and silver levels, then an automatic email be sent to myself and 5 other people.
The routine and bronze do not need email notifiation, but the gold and silver does. I have a feeling I may have to do something in Power Automate but I am not 100% certain on this.
Any tips or advice would be greatly appreciated.
Thanks in advance.
DRJ
Thanks for your reply. I have resolved it in the following way:
I have set up cards that show the count of silver or gold cases, then set up a trigger that if it goes above 0 then an email notification will be sent. I did this using Power Automate.
2 Replies
- lbendlin
Super User
Dashboards don't refresh. Datasets refresh.
Yes, use Power Automate to run DAX queries against your dataset and based on the query results send out your email.
You can also use Power Automate to initiate the dataset refresh request and monitor the progress of the refresh.
DRJ1994Thanks for your reply. I have resolved it in the following way:
I have set up cards that show the count of silver or gold cases, then set up a trigger that if it goes above 0 then an email notification will be sent. I did this using Power Automate.
