Forum Discussion

robbert-bi's avatar
robbert-bi
Helper I
1 year ago
Solved

Set alerts on table visualization

Hi all. I have a challenge regarding alerts in Power BI Service. I have a table visualization which looks like below (I recreated it in Excel, but it looks the same in Power BI). Every record represe...
Need Help
  • AnkitKukreja's avatar
    AnkitKukreja
    1 year ago

    Hi! robbert-bi 

    You have to look out of Power BI for this. You can use Python scripts or Power Automate (PA).

    For PA you can use dax like:

    AlertFlag = IF([Excess Percentage] > 0, 1, 0)

    then you can create a table viz and necessary use other necessary cols, use it in PA viz and create a flow to send out emails.

     

     

     

     

  • rohit1991's avatar
    rohit1991
    1 year ago

    Solution:

    1. Add an Alert Flag: Create a calculated column in Power BI: AlertFlag = IF([ExcessPercentage] > 0, 1, 0)

    2. Power Automate Integration: In Power BI Service, trigger a Power Automate flow for flagged rows. Use "When a data-driven alert is triggered" in Power Automate to send emails to project managers and stakeholders.

    3. Test & Activate: Test the flow and activate it for real-time alerts.