Skip to main content

Power BI

Needs Votes

On Premises Data Gateway/Dataset - Email notification when failure improvment

Vote (61) Share
POINTEAU Michael's profile image

POINTEAU Michael on 26 Jun 2017 21:53:26

I have just experienced a bad weekend return. All users complaining that their reports/dashboards were not operating anymore.

I quickly discovered that both On Premises Gateways (DEV and PROD) were "down", "Unable to connect: The gateway is either offline or could not be reached".



Microsoft support did not provide a reason, but instead suggested frequent update of the OPG, as well restart of the associated Services on the machines when something is going wrong.



I asked why should we wait for end users to complain, prior taking action, as PowerBI service knows there are some refresh issues, as this is shown to me immediately on the Manage Gateways portal?



I was suggested to raise idea... Great so here I am.



So for Microsoft sake and I believe every IT organization that wants to keep trust from end users, we need:

-Capability to set 'alerts's on any dataset refresh failure. I say ANY because I discovered few hours after the start of my investigations that I got some Failure to refresh notifications in my Outlook Clutter folder..... Clutter: not good. I need to fix that. But I also realized that only few datasets were sending such. Investigating a bit more, it seems my datasets "Live Connected", "Direct Query" not needed a refresh setup per se, won't allow to setup such 'alerts'. On the opposite, Excel based, Folder based dataset are allowing me to setup the "Send refresh failure notification email to me".

-Capability to add multiple recipients for that notifications, including Active Directory distribution groups to ensure such issues are addressed asap.

Comments (1)
POINTEAU Michael's profile image Profile Picture

Craig Porteous on 05 Jul 2020 23:06:18

RE: On Premises Data Gateway/Dataset - Email notification when failure improvment

Voted! Ive blogged about a workaround in PowerShell if that helps you until MS sort it...

https://www.sqlshack.com/manage-power-bi-dataset-refresh-failures/