Crear alerta

Hi Gaspar89 

Not entirely sure, but what may work best in this case is to move away from the native Power BI alerts and use Power Automate instead.

From your description, the semantic model is refreshed every day at 9:00 AM with data from the previous day, and you need to receive a notification only after that refresh has completed and only when the card value is greater than 0.
A possible approach would be:

1. Create a flow in Power Automate.
2. Use a trigger such as "When a semantic model refresh completes" (if available in your environment).
3. Add an action to query the value behind the card.
4. Create a condition:
   • If the value is greater than 0 → send an email, Teams message, or push notification.
   • If the value is 0 → do nothing.

If the refresh completion trigger is not available, another option is to schedule the flow to run shortly after the expected refresh time (for example, 9:15 or 9:30 AM), allowing enough time for the refresh to finish before checking the data.

This approach is generally more reliable than Power BI's native data alerts because it gives you control over when the evaluation takes place. Native alerts can be checked by the service at intervals that do not necessarily align with your dataset refresh schedule, which explains why you may receive notifications overnight or every hour.

For more information, see the Microsoft documentation:

Integrate Power BI Data Alerts with Power Automate - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn

Note: I translated the original post and there may be some translation inaccuracies.