Email trigger based on refreshed data

[RichOB]

Hi, I'm not sure if I'm in the right place for a Power Automate/email trigger question. 

I have Salesforce linked to a PowerBi report, the report is on a daily refresh which has information about student accommodation. I need to set up an email alert from PowerBi (Not Salesforce) to send the CEO when there's an altercation in one of our locations. So in the example, the CEO would get an email on the 13th April refresh saying something like:

"There has been an altercation today (13/04/2025) in Newcastle involving Jason and Matt."

Is it possible to have a triggered email from what the tabled data reflects in a refresh?

Name	Date	Altercation	Location	Involving
Dave	10/04/2025	No	Manchester	Paul
John	11/04/2025	No	Edinburgh	Lloyd
Mary	12/04/2025	No	Bristol	Rhys
Jason	13/04/2025	Yes	Newcastle	Matt

Thanks

Rich

[v-saisrao-msft]

Hi @RichOB,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @RichOB,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @RichOB,
I wanted to check if you had the opportunity to review the information provided by @bhanu_gautam. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[bhanu_gautam · Accepted solution]

@RichOB , You can try to create flow

Create a Power Automate Flow:

Go to Power Automate and create a new flow.
Choose the trigger "When a data-driven alert is triggered" from Power BI.
Set Up the Power BI Alert:

In Power BI, create a data alert on the specific visual or data point that indicates an altercation.
For example, you can set an alert on a measure that counts the number of altercations and triggers when this count is greater than 0.
Configure the Flow:

In the flow, after the trigger, add an action to "Get rows" from the Power BI dataset.
Filter the rows to get the specific data where Altercation is Yes.
Send an Email:

Add an action to send an email (e.g., using Office 365 Outlook).
Configure the email body to include the details from the filtered data, such as the date, location, and individuals involved