Email trigger based on refreshed data

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