Create Work Item if Power BI alert is sent
Every week, create a Azure DevOps 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.