Sanity testing for data in dashboard

[Anonymous]

Is there any way to perform automated sanity testing for the data in my dashboard

I essentially want a way to flag each row that has the due date as blank. Then to get a list of these rows and send it in an email to be reviewed.

Is this possible? 

[Shishir22]

Hello @Anonymous ,

You can create a paginated report having just data with due date as blank and add a email subscription in form Excel Workbook(XLSX). Pagingated reports support subscription in XLSX.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe?tabs=creator

Please mark it as answer if it resolves your issue. Kudos are also appreciated.