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 ,
|In Power BI Service, alerts on dashboard tiles only trigger when Power BI detects a data change, but for DirectQuery-based reports, alerts do not automatically refresh in the background. Since DirectQuery fetches data on-demand, the dashboard tiles do not update in real-time unless the dashboard is actively opened or manually refreshed. This is why your alert only triggers when you open the dashboard.

A possible workaround is to set up a scheduled cache refresh in the dataset settings, which forces Power BI to refresh the tile periodically. Additionally, if the data source allows, consider using Hybrid Tables (import mode for historical data and DirectQuery for real-time data) to balance performance and alert functionality. If near real-time alerts are essential, you may need to integrate Power Automate to monitor data changes and send notifications independently of Power BI’s built-in alert system.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar

[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