cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gemidriver Regular Visitor
Regular Visitor

Receive email for Refresh failure

Is it possible to setup email alerts if a scheduled refresh fails?

13 REPLIES 13
v-yulgu-msft Super Contributor
Super Contributor

Re: Receive email for Refresh failure

Hi @gemidriver,

 

At the moment, it is not supported to setup email alert for scheduled refresh failure.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gemidriver Regular Visitor
Regular Visitor

Re: Receive email for Refresh failure

ok so it isn't supported

is there something that can be used ?

we have some schedules failing to refresh, and it would be great to be able to be notified in some way

cheers

v-yulgu-msft Super Contributor
Super Contributor

Re: Receive email for Refresh failure

Hi @gemidriver,

 

The scheduled refresh history will be recorded in Power BI Report Server database hosted on SQL Server. Maybe you could configure an alert in SQL Server when the state of scheduled refresh is recorded as "Failure" which will send an email to specific recipients.

 

Reference: PBIRS scheduled refresh data refresh: Execution history
                  Query Details of given SSRS Report from ReportServer Database tables

                  Send an email from a trigger

                  Get an alert when a certain record changes in SQL Server

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gemidriver Regular Visitor
Regular Visitor

Re: Receive email for Refresh failure

Hi

Any ideas on tables/columns to monitor?

seena Frequent Visitor
Frequent Visitor

Re: Receive email for Refresh failure

You can schedule refresh at the dataset level. Goto Schedule refresh and select below option at the bottom of where you enter the schedule time.

 

Send refresh failure notification to me

gemidriver Regular Visitor
Regular Visitor

Re: Receive email for Refresh failure

please explain?

we have different types of error messages

 

refresh at dataset level?

we have to setup a refresh on each report

what i would like is someway of knowing if a refresh has failed

PeterNesbitt Frequent Visitor
Frequent Visitor

Re: Receive email for Refresh failure

Scheduled refreshing is done at the dataset level for the Power BI Service. Reports will use the latest data that is in the dataset it connects to.

 

There's limited email notification settings for a refresh failure, but you can tick the 'Send refresh failure notification email to me'. I can confirm this works (example below) Smiley Happy. I'm not sure if this sends an email to all owners of the workspace or not, someone else may be able to confirm that.

Refresh.PNG

 

Refresh Failure.PNG

gemidriver Regular Visitor
Regular Visitor

Re: Receive email for Refresh failure

we are using the on premise report server - not the cloud version

PeterNesbitt Frequent Visitor
Frequent Visitor

Re: Receive email for Refresh failure

Ahh yes! My apologies, I jumped the gun. Man Frustrated It seems you and I both did not read the reference articles that Yuliana Gu posted above. Noteably, https://workingondata.wordpress.com/2017/11/02/pbirs-scheduled-data-refresh-execution-history/

 

That contains all the details we are after Smiley Happy

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 102 members 1,481 guests
Please welcome our newest community members: