Forum Discussion

xantari's avatar
xantari
Icon for Helper II rankHelper II
8 years ago

Scheduled Refresh notifications (On-Premise)

We can not find a way to get Refresh Notification failure emails when a scheduled data refresh occurs on-premise.   Apparently this has existed for a long time on Power BI (because they have to dea...
Power BI Report Server
Anonymous's avatar
Anonymous
Not applicable
8 years ago

In Power BI report Server, every schedule you create goes to SQL Server Agent JOB, so you can go to the SQL Server Agent JOB and then you can add one more step after the current step for sending the email. You might need to configure email in SQL in order to send the email through JOB.

xantari's avatar
xantari
Icon for Helper II rankHelper II
8 years ago

WHich one of the 150 SQL Agent jobs do I do that on. They are just labeled as a GUID.

 

This doesn't seem like a good solution.

 

Microsoft needs to fix this if there is no other way. Why don't they just add a task at the end of these SQL Agent jobs for the server administrator if it is setup in the Power BI Server backend? 

 

Seems like basic functionality is missing here.