Skip to main content

Power BI

Needs Votes

Send Refresh Failure Notifications to Distribution List

Vote (1185) Share
Kate's profile image

Kate on 11 Jun 2019 22:35:27

It would be helpful to be able to set up a distribution list of those to send refresh failure notifications to. Currently, only the owner receives an email, but we have several administrators that require notification when certain reports fail.

Comments (50)
Kate's profile image Profile Picture

2826746b 8215-4a3d-9ec2-66c1eaa6166e on 05 Jul 2020 23:46:46

RE: Send Refresh Failure Notifications to Distribution List

Improved error messages needs to happen. I just get a message that says, file is corrupt. Which file?! There are hundreds!

Kate's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:42:27

RE: Send Refresh Failure Notifications to Distribution List

Power-BI came out 3.5 years ago and we are missing this one critical feature.
We are using Outlook rules from past 2 years, but this is not a best way as we have different DL for different reports.

For Example Dev vs Prod

We do not want to send the email notification for business users for the development reports.

Kate's profile image Profile Picture

55e90c01 fb03-45e7-a78a-5df3a9bf4fae on 05 Jul 2020 23:41:59

RE: Send Refresh Failure Notifications to Distribution List

Fuck

Kate's profile image Profile Picture

6f1c1d48 b187-4735-b9ea-ecbd0b70e165 on 05 Jul 2020 23:39:00

RE: Send Refresh Failure Notifications to Distribution List

maybe you could define and use forwarding rules in MS Outlook for example (at least as a workaround)

Kate's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:38:58

RE: Send Refresh Failure Notifications to Distribution List

Necessary when you have a team maintaining PBI, which is the case at many medium/large companies.

Kate's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:38:58

RE: Send Refresh Failure Notifications to Distribution List

Should be able to specify a list of email addresses to notify through the On-Premises Gateway? That would be a great feature.

Kate's profile image Profile Picture

52b5cce4 5162-45fc-a468-4609777326e8 on 05 Jul 2020 23:38:51

RE: Send Refresh Failure Notifications to Distribution List

Great idea

Kate's profile image Profile Picture

d79eaffb 8311-46be-9c3d-f121fefdd258 on 05 Jul 2020 23:38:20

RE: Send Refresh Failure Notifications to Distribution List

Please add the name off Workspace into e-mail about Refresh failed. There is on Activity ID and Request ID and it would be really helpfull to know which workspace has trouble with refresh.

Thank you

Kate's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:35:20

RE: Send Refresh Failure Notifications to Distribution List

'Really the logging needs to include:
- Workspace name (or ID)
- Dataset name (or ID)
- Query name
- Error details

I just posted the following comment on:
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available-2/

It is very hard to troubleshoot gateway refresh errors currently.
As far as I can tell (and the Microsoft support person who I raised a support call to), the gateway logs contain no information that you can use to find out which dataset in which workspace is a associated with a given failure.
This makes management of the Gateway very difficult. Power BI can retry refreshes multiple times, even when the refresh is destined to always fail (e.g. due to changes in the data source). This consumes a significant amount of resources in (1) data sources, (2) network, (3) gateway and (4) the Power BI Online service. So what appears as a mere annoyance, in a large organisation can have significant resource and capacity implications.
In a large organisation where many people and teams are using the same enterprise gateway, this can make the gateway very hard to manage (and the number of failing datasets can just increase over time).
Please Microsoft address this issue. At the moment you have what looks like a big design flaw in the logging mechanism that needs to be addressed.

Kate's profile image Profile Picture

2859aa13 0aca-45c3-918f-e1741339ea0c on 05 Jul 2020 23:34:01

RE: Send Refresh Failure Notifications to Distribution List

I'm surprised they still haven't addressed this. It's such a seemingly easy request to include the workspace name in any e-mail and/or message regarding refresh status for a particular dataset. As others have mentioned we have multiple environments and workspaces with the same dataset name.