Forum Discussion
Alerts option not available
Super User
bcincy99 wrote:Does the data source matter? I'm using Direct Query datasets using Azure Sql.
Yes it does, the documentation I linked previously says that alerts are only supported on data sets that are refreshed. (the alerts are evaluated after the refresh). This could be your issue as Direct Query models are not refreshed by the Power BI service.
Are Import datasets refreshed? Wondering if I should change my KPI query to use this instead.
- d_gosbell
bcincy99 wrote:Are Import datasets refreshed? Wondering if I should change my KPI query to use this instead.
They are if you configure a scheduled refresh. Basically it sounds like the alert threshold would be checked each time the scheduled refresh runs.
Hmmm...changed my KPI to use an Import instead of direct query, published it, added a scheduled refresh, pinned to my dashboard, and still no alerts option in the elipsis menu.
- d_gosbell
bcincy99 wrote:Hmmm...changed my KPI to use an Import instead of direct query, published it, added a scheduled refresh, pinned to my dashboard, and still no alerts option in the elipsis menu.
Sorry, I don't know why that would be. I did the same thing on my test tenant (as we are using the on-prem Report Server at work which does not support alerts) And I get the alerts option from my dashboard tile even before I setup the refresh schedule (the alert would just never get triggered if the data set is not refreshed)
Maybe try asking on the service forum here or raising a support ticket off the Power BI page.