Create a Work Item if a Power BI data alert is sent on a Monday

Power BI

Power BI

Office 365 Users
Azure DevOps
Office 365 Outlook
Excel Online (OneDrive)

Office 365 Users, Azure DevOps, Office 365 Outlook, and Excel Online (OneDrive)

Every week, create an Azure DevOps work item to address active Power BI Alerts 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 (OneDrive) spreadsheet to prevent lost alerts. The spreadsheet must have a Table with columns of Title, Value, Threshold, Triggered, URL, Weekday and Date.