Dynamic Email Notifications for Incorrect Data: Seeking Guidance

[Learner27]

Hello Community,

I have a requirement to send email notifications to users whose data is incorrect. I want this to work dynamically, meaning that after I refresh the dataset, users with incorrect records should be automatically notified via email.

I've attempted this with Power Automate, but it seems to work only manually.
I need it to function dynamically without needing manual triggering.
Can anyone help me with the conditions I should set in the flow or suggest functionalities that could achieve this?

Thanks in advance for your assistance."

[Anonymous]

Hi @Learner27 ,

Have you solved your problem?
If not, you can try Data Activator, which has almost the same functionality as an alert, but it is much more widely available than an alert.
Introduction to Data Activator - Microsoft Fabric | Microsoft Learn
But at the same time it has more limitations than alarms, such as having to be in premium capacity:
Data Activator limitations - Microsoft Fabric | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @Learner27 ,

did you try the alert https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

[Learner27]

Hello @Idrissshatila,

Thank you for sharing the link regarding Alerts. It seems applicable to specific tiles like Gauge Visual and Card Visual.

However, in my case, I'm utilizing a table as my visual, with a specific column containing various rows. I aim to send email notifications to users based on that specific column.

While I attempted to use alerts, it seems challenging to achieve in the context of a table visual.

Could you kindly guide me on how to manage alerts specifically within a table visual?

[Idrissshatila]

@Learner27 ,

you could maybe set a column that says that if there's an error to display 1, and set it in a guage that when number us greater than 0 to send an alert.

[Learner27]

Hello, @Idrissshatila 

I attempted to place my column in the card visual, but it's displaying zero because the data is related to timely actions. Unfortunately, the Gauge visual is not applicable in my Power BI 

Desktop. Anyways, thanks for the suggestion.

If you have any ideas on how to work directly on the table itself, please provide assistance.