Forum Discussion

Prabhat96's avatar
Prabhat96
New Member
1 year ago
Solved

Alerts on dashboard

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

Need Help
Tips and Tricks
  • collinq's avatar
    collinq
    1 year ago

    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.

8 Replies

  • andrewsommer's avatar
    andrewsommer
    Super User
    1 year ago

    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

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    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.

  • collinq's avatar
    collinq
    Super User
    1 year ago

    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's avatar
      Prabhat96
      New Member
      1 year ago

      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's avatar
        v-saisrao-msft
        Community Support
        1 year ago

        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.