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-ssriganesh]

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

[v-ssriganesh]

Hi @RichOB,

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

Thank you.

[v-ssriganesh]

Hi @RichOB,
Thank you for reaching out to the Microsoft Fabric Community Forum. I appreciate @lbendlin & @Cookistador for their valuable suggestions.

Yes, it is possible to set up an email alert to notify the CEO when an altercation is reported in your Power BI report after the daily refresh. The most straightforward way to achieve this is by using Power BI data alerts and Power Automate to send a customized email with details like the date, location, and individuals involved, without relying on Salesforce. For more details, please refer to the following official Microsoft documentation:

• Set data alerts in the Power BI service – Explains how to set alerts on dashboard tiles to monitor data changes.
• Integrate Power BI data alerts with Power Automate – Guides on using Power Automate to send customized emails triggered by Power BI alerts.
• Data alerts in Power BI dashboards – Provides information on configuring alerts in Power BI dashboards.
  
  

Regarding @Cookistador’s suggestion, if your workspace is using Microsoft Fabric, Data Activator could be an alternative for triggering actions based on data conditions (see Introduction to Data Activator). its email notification capabilities may be limited compared to Power Automate for your specific need for customized emails.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[Cookistador · Accepted solution]

Are you using Fabric?

Because it is definitely the purpose of Data activator (https://learn.microsoft.com/en-us/fabric/real-time-intelligence/data-activator/activator-introductio...)

[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

[lbendlin]

There is no trigger "when a semantic model refresh has completed".  You would need to create your own polling flow to check for the (successful!) completion of the refresh, and then you would run a DAX query against the semantic model and stuff the results into the email.