Forum Discussion
Power BI Alerting Thresholds
Greetings All, I am trying send alerts based on a table or matrix of thresholds, for example If Monday exceeds 100,000 send a notification. I understand I could set up 7 individual alerts, but that doesn't seem to scale very well especially if we have 100 stores? These thresholds could be configured via a DAX measure, but the stepping through the table to trigger alerts is where I am stumped.
Example Below
| Day | Alert Threshold |
| Mon | 100000 |
| Tue | 200000 |
| Wed | 300000 |
| Thu | 400000 |
| Fri | 500000 |
| Sat | 600000 |
| Sun | 700000 |
1 Reply
This won't be realistic using the Power BI alerts because you are right - it won't scale. If you are on Premium or Premium Per User, you can use the Power Automate action to run a query against a dataset. You can then use Power Automate to iterate over those results. To write a query, you'd need DAX Studio (free). To figure out how to iterate over the data in Power Automate, the Power Automate forum would be the best route.
If you do not have any type of Premium, and are in a Pro workspace, you cannot do this as you cannot run queries against the XMLA Endpoint in Pro.
