Send alert email in case a user gets an error on PowerBI regular report with Direct Query DataSet

[Anonymous]

Hi,

We are using PowerBI service with regular reports with Direct Query DataSet for our company users, so every time a user opens such report, it makes query to data source (in our case it is Azure Analysis Services) and displays data to user.

In case of any problem (AAS model is corrupted or firewall settings changed and there is no access to AAS, or user permissions on AAS changed), user gets an error popup, but we can not get any error message about is before user would raise a ticket in the company support. 

Currently I see functionality on sending alert emails in case of a report with scheduled refresh dataset (it is described here https://powerbi.microsoft.com/en-us/blog/sending-refresh-notifications-to-others/), but it doesn’t work for Direct Query reports.

What can we do to achieve alerting system or monitoring dashboard of users errors in our case?

Thanks

[Anonymous]

Hi @Anonymous ,

You could use SQL Server Profiler whose main purpose is to monitor the activity in your SQL Server instance.

You could also refer to these blogs for reference.

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

https://radacad.com/exception-reporting-in-power-bi-catch-the-error-rows-in-power-query

https://www.youtube.com/watch?v=GWAWPCAjkEY

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi Eyelyn Qin,

We don't have SQL Server instance in this scenario.

It is PowerBI service and Azure Analysis Services as a source.

Also, making sure that AAS is healthy doesn't guarantee that a PowerBI report works for a user, as there could be various data model or access errors or an error in PowerBI report itself.

So we aim to monitor errors on PowerBI side, not on data storage side.