Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have developed a report to monitor system parameters. If any of the parameters change, I need some sort of notification or alert. So I have two questions:
1. Is Power BI capable of automatically generating an email if a value in a table changes. That is - I have a column where if the value is anything greater than 0.00, I would like an email to be sent.
2. Is it possible for an alert to be generated if a table value changes. As above, if the column value is greater than 0.00, an alert is triggered.
Thank you in advance
Solved! Go to Solution.
I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.
I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal
Hi @anderb ,
you can't use tables for your notifications but you can use dashboard and tiles. There is possibility to set up power automate flow, which can send any kinds of notifications.
Details are here:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
Thanks for you response @Migasuke . I'm surprised some sort of alert or notification can't be generated from a table value.
Alternativly - is it possible to highlight a linked slicer based on a change in cell value?
Thank you
Hi,
how should it work? I am not sure if I get it.
Hopefully the screenshot below explains it a little better. So as an example:
If the value in the AvgDespatch column is greater than 5, highlight the associated country in the slicer.
I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.
I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |