Forum Discussion
Helper IAlerts in Power BI
Hi.
I have enabled alerts on few tiles in a dashboard. and sending emails to users when a metric (Sales Amount)exceeds the threshold using Power Automate through Data Driven Alerts.
But how we send in email on what is actual value of metric(Sales amount) ?
Hi Rajesh_Yarlagad,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.
3 Replies
- GilbertQ
Super User
The only way I can think to get this working is you will then need to create a power bi report, which would then show the Sales amount. What you could then send as part of the power automate flow.
v-pnaroju-msftCommunity Support
Thank you, GilbertQ , for your response.
Hi Rajesh_Yarlagad,
We appreciate your inquiry on the Microsoft Fabric Community Forum.
Kindly follow the steps mentioned below, which may help resolve your issue:
- Create a dataset in Power BI and ensure that the sales amount metric is included in the dataset.
- When a Data-Driven Alert is triggered, use the appropriate action in Power Automate to query the dataset and retrieve the Sales Amount value.
- Add the retrieved value to the email body.
Additionally, please find the relevant reference links below:
Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Learn
Tutorial for setting data alerts on Power BI service dashboards. - Power BI | Microsoft LearnIf you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
- v-pnaroju-msft
Hi Rajesh_Yarlagad,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.
