Alerts on dashboard

[Prabhat96]

Hi All,

I have created a report using DirectQuery method and then have created a dashboard using a card visulaisation from the report. Added an alert to the dashboard tile but it's not getting triggered automatically. Alert gets triggered when i open the dashboard.
Appreciate some help over here!

Thanks,
Prabhat

[rohit1991]

Hi @Prabhat96 

This is a known limitation with DirectQuery alerts only trigger when data changes are detected, but with DirectQuery, data is only fetched when the report or dashboard is actively viewed.

Even if your dataset is refreshing daily, the dashboard tile itself may not update unless a scheduled tile cache refresh is set up. That’s likely why the alert only fires when you open the dashboard.

Few options as well:

• Set up a scheduled cache refresh in the dataset settings to keep the tile updated.

• For real-time alerts, tools like Power Automate can monitor your data source and send notifications independently.

• For long-term needs, consider Hybrid Tables to balance import and real-time data.

[andrewsommer]

Your data needs a scheduled refresh if you want an automated alert.  Switch to Import mode or set up an automated refresh for your direct query

[collinq · Accepted solution]

Hi @Prabhat96 ,

An alert only sends when the data for that alert is refreshed.  But, since this is direct query,   If you are not refreshing the Direct Query report automatically, the only time that the data is queried is when the dashboard is opened. So, that part tracks with your comment.  Therefore, I think taht if you schedule refreshes, you should be getting alerts.

[Prabhat96]

Hi @collinq ,

The report is scheduled to refresh daily. However for a safer side, i have scheduled the page to refresh after every hour from "format report page"

[v-saisrao-msft]

Hi  @Prabhat96,

Thank you for reaching out to the Microsoft Fabric Forum Community. 

Thank you for providing detailed information about your issue. I understand that the alert on your Power BI dashboard is not triggering automatically and only works when the dashboard is opened.

• Please confirm that the scheduled refresh is carried out successfully. You can check the refresh history in Power BI to ensure the data is being updated as expected. 

Please let us know if you have any updates or additional details that might help us assist you further. 

[Prabhat96]

Hi @v-saisrao-msft ,

The scheduled refresh is working fine and refreshes once a day

[v-saisrao-msft]

Hi @Prabhat96,

As you mentioned that your scheduled refresh is working fine and refreshes data once a day, could you please confirm if your issue has been fully resolved?

[Prabhat96]

Yes, the issue has been resolved