Create Work Item if Power BI alert is sent

Power BI

Power BI

Azure DevOps
Office 365 Outlook
Excel Online (Business)

Azure DevOps, Office 365 Outlook, and Excel Online (Business)

Every week, create a Visual Studio work item to address active Power BI Alerts which is sent on a Monday with a link back to the relevant Dashboard. Then send an email with a link to both the work item and the dashboard. Track alerts that occur the rest of the week in an Excel Online (Business) spreadsheet to prevent lost alerts. The spreadsheet must have a Table with columns of Title, Value, Threshold, Triggered, URL, Weekday and Date.