Forum Discussion
Set alerts on table visualization
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.Solution:
-
Add an Alert Flag: Create a calculated column in Power BI: AlertFlag = IF([ExcessPercentage] > 0, 1, 0)
-
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.
-
Test & Activate: Test the flow and activate it for real-time alerts.
-
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.
Hi AnkitKukreja. Thank you very much for your reply! I will look into this. However, isn't there a solution in Power BI itself? Or with Data Activator?
Hi AnkitKukreja . Yes I know that I can only use a KPI, gauge or card and that is exactly the problem, because I have a table visualization. So I can't work with a KPI, gauge or a card.
But if I understand you correctly, it is not possible in Power BI and I will have to use Power Automate?
