Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Refresh dataset with powershell (change mail)

When using this command in powershell

 

#5. Execute refreshes with mail on failure

$MailFailureNotify = @{"notifyOption"="MailOnFailure"}

Invoke-PowerBIRestMethod -Url $RefreshDSURL -Method Post -Body $MailFailureNotify

 

Is it possible to specify other "notification on failure" emails ? if yes, how?

3 REPLIES 3
malafaiabarbara
Frequent Visitor

I have the same problem.

Anonymous
Not applicable

Hi @Anonymous ,

Please review the following blogs, hope they can help you resolve the problem.

REFRESH POWER BI DATASETS WITH POWERSHELL

Managing Power BI Dataset Refresh Failures

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Anonymous
Not applicable

I read the first post before coming here with this problem and it doesnt mention you can change the mail.

The second its true that it covers a way to notify errors with email but you have to create another powershell , get the history, import it from powerbi, schedeule it, create a dashboard with changes and subscribe those changes..... too much work.

 

The problem is im not receiving emails from dataset errors unless they are scheduled in the powerbi portal. Currently, all of our datasets in the company refresh using powershell in the middle of Data Warehouse load.

powershell is using my account (email)

 

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.