You need to build a Power Bl dashboard for sales managers to track opportunities. When a new sale closes that is greater than S1 million, a notification must pop up and an email must be sent to the…

Question

Options

• Aa Power Automate flow: This flow will trigger when a sale closes and its value is greater than
• Ba calculated column in the Dataverse
• Ca custom connector
• Da paginated report to save to Microsoft OneDrive
• Ealerts in Power BI: This alert will pop up a notification in the Power BI dashboard when a new

• A
  80% (20)
• B
  4% (1)
• C
  12% (3)
• D
  4% (1)

Explanation

The solution requires both a pop-up notification in Power BI and an email to leadership when a sale exceeds $1M, without modifying Dataverse. Power BI alerts (E) can be configured on dashboard tiles backed by streaming or report data; when a value crosses a threshold (sale > $1M), the alert fires and displays a pop-up notification in the Power BI service. That same alert can trigger a Power Automate flow (A), which then sends the email to the leadership team. This combination satisfies both requirements without touching Dataverse schema. A calculated column (B) modifies Dataverse. A custom connector (C) is for integrating third-party APIs. A paginated report to OneDrive (D) is a reporting export action unrelated to alerts or email triggers.

No community discussion yet for this question.