Forum Discussion

UserBrendan's avatar
UserBrendan
New Member
8 months ago
Solved

Power BI Alert Activator - MaxDelayReached Error

Hi, I am getting the issue below for my alerts because it is not a consistent alert that occurs withing seven days. However, it is still an important alert that needs to be sent to stakeholders.  W...
  • v-echaithra's avatar
    8 months ago

    Hi UserBrendan ,

    Your alert is tied to table visuals and only triggers when specific rows meet certain criteria. Data Activator treats these row updates as “incoming data.” When no new or updated data is received for over seven days, the rule becomes inactive, resulting in the MaxDelayReached message.

    To avoid this, the most reliable solution is to ensure that Data Activator receives some form of data at least once every seven days even when the alert condition itself is not met. This keeps the rule active and able to evaluate future conditions.

    A simple way to achieve this is to introduce a small “alert” update. You can schedule a query or pipeline via Power Query, SQL job, Fabric pipeline, Dataflow Gen2, etc. that sends a lightweight row such as:

    LastUpdated = <today’s date>

    Status = "alert"

    This row won’t might trigger your alert but will keep the rule alive and prevent MaxDelayReached.

    Hope this helps.
    Thank you.