Forum Discussion
need a daily Alert
Hi. I don't get it. Were you able to configure the alert? the power bi alert configuration step 4 is asking you if you want it daily or hourly:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts#set-data-alerts-in-the-power-bi-service
That's the only place to configure alert in Power Bi by default. If you have XMLA endpoint you could execute a query to the dataset by API and send de alert, but you would need coding scripting skills to build it.
I hope that helps,
Hello. Yes i could configure it. Every 24 Hours because we update data once a day. But in the configuration it is written that Alters are only sent if your data changes. And IF([price] >= [price_plan] * 0.25, 1, 0) is every day 1 as long as [price] >= [price_plan] * 0.25. Hence no alerts.
Oh. I see now. You may be able to cheat that changing the 1 from the TRUE response of the if with something like:
RAND() + 1Sum a random value from 0 to 1 + 1. Then you will always get a different value like 1.23 or 1.54
That way the value will change and be higher than 0.
I hope that helps,