Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
4 years ago

need a daily Alert

hi all,

 

there are really less options for alerts in power bi service! i have created following dax formula in PBI Desktop:

 

Alert = IF([price] >= [price_plan] * 0.25, 1, 0)
 
and put it in a card. In PBI Service i say in a dashboard when Alert > 0 give an Alert. So i just get an Anlert one time (because 1 > 0) and no more because currently it is every day [price] >= [price_plan] * 0.25. I suppose we get only an Alert when the data changes and 1 doesnt change every day?
 
Are there some techniques to get every day an Alert when it is 1?
 
thanks for ideas.
Need Help

3 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    4 years ago

    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,

    • Pikachu-Power's avatar
      Pikachu-Power
      Impactful Individual
      4 years ago

      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. 

      • ibarrau's avatar
        ibarrau
        Super User
        4 years ago

        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() + 1

        Sum 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,