Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Videos          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

Power BI Online Alerts


By:   |   Read Comments   |   Related Tips: More > Power BI

Problem

Can Power BI alert me when data changes? How can I be made aware of changes in specific values on my dashboard?

Solution

Power BI has added automated alerting functionality to the online Power BI dashboard tool set. This functionality allows a dashboard viewer to request notifications of when specific values changed within a tile on a report. As with any tool, several caveats exist. First, only gauge and card tiles that are numeric in nature can be used as the basis for an alert. Any tile that includes a time series or Bing data source is also ineligible for alert usage. Furthermore, the data must of course be on a refresh schedule to be evaluated for the alert to be generated. Finally, this functionality is only available to be setup in Power BI online or on your mobile device.

To get started with Alerts, you need to do a few things to get everything setup for access including signing up. Note that you must use a work or school address to sign up for Power BI. Gmail, Yahoo, and similar accounts will not work. Once you have your account setup, you are ready to start exploring the Alerting features available in Power BI.

Ping Me Power BI

In the below screen print, I created a basic dashboard using the Wide World Importers database which is available from Microsoft. This sample database is a quasi replacement for the Adventure Works sample databases that many have used for a number of years. I highly recommend that you review Koen Verbeeck's great series of tips on these new sample databases; you can find part 1 on MSSQLTips.com.

PowerBI Main Dashboard

In the above example we have two visualization tiles on our sample dashboard. However, the cross tab table on the left is not eligible for alerts, while the number card on the right is eligible. To get to the settings menu, you click on the ellipse in the upper right hand corner of the card tile. By clicking on the settings menu, we are then presented with a list of options, one of which is a "bell" button that allows us to manage alerts.

Setup Alert in PowerBI

In a similar fashion, clicking on ellipse for a gauge, provides similar functionality. The "bell" button though, would be missing completely for tiles, such as the cross tab noted previously.

Guage tile in PowerBI

Guage to add an Alert in PowerBI

After clicking the Manage Alert button, we are shown the Manage Alert screen. Here we can add a new alert or, if created, modify an existing alert. Thus, we create a new alert by clicking the Add Alert Rule button.

Add Alert Rule in PowerBI

For the rule itself, as illustrated below, you set the active flag, the alert title, the measure to evaluate, the condition to use for the evaluation, the threshold number, the notification frequency, and the flag to email the alert. As noted, the alert will not be initiated unless the data changes. In order for the data to change, the data set must be set up on a refresh schedule.

Setup an Alert in PowerBI

Alert condition and threshold

Setup email notification in PowerBI

Once the alert is activated and the alert threshold is met, it will automatically show in several places. First, on the Power BI online site, you will see a notification in the Menu area as shown below. Clicking on the notification button, shows the actual Alert with the actual value and the threshold value.

PowerBI Notification Center

Additionally, the alert sends a notification to my mobile devise (an Android phone in my case). Again the mobile alert is completely automated with each change in the data (you do need to be singed into the Power BI site on your mobile device).

PowerBI Mobile Alert

Mobile alert notification

Finally, an email is sent to the email address on record for my Power BI account.

Email Alert from PowerBI

Notice how all the alerts direct you back to the Power BI site for you to further research as to why the alert took place. I am hoping, though, that Microsoft adds some formatting to the numbers in the notifications (see above email example).

IIf we want to maintain the existing alerts, two ways are available to change or delete existing alerts. Either, you can click on the ellipse button on the tile you would like to change, and then select the Alert button again. As shown below, we can click on the down arrow just to the left of the Alert Title. We could also delete the alert from this screen by clicking on the trash can button.

Manage alerts in PowerBI

Alternately, we can click on the Gear button on the main Power BI online screen, and then select Settings.

Settings gear in PowerBI

Next, we would click on the alert tab which presents us with a list of all our alerts. From here we can delete the alerts, edit the alerts, or use the yellow slider to turn the alert off and on.

Maintain alert in PowerBI

On my Android device, I also have the option to maintain my alerts on the go.

Maintain mobile Power BI Alerts on Android

Conclusion

Throughout this Power BI tip, we discussed the new Alert functionality. Alerts can be setup and maintained via Power BI online or via your mobile device (not in the desktop version).You can setup alerts via specific tiles on any available dashboard; however, as of now, alerts are only available for card and gauge visualizations and are not allow on any tile using a time series.

Next Steps


Last Update:






About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips


 









Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools