How to get proactive notification if power bi report parameters dont have data or report is down

[sonsh]

Hi,

We have went through this scenarios wherein we reactively received couple of issues from our users related to our power bi report being down.

How can I proactively set notifications / alerts if something like this happens :

• Parameter doesnot have data at all because of one backend table being truncated?
• Report doesnot render / open at all?
• Any of my visual has some issue?

I know power bi altert feature is there but it has limitations only on Numeric data. like KPIs , scorecard etc.

We only have graphs and tables in our report  hence power bi alert is not helpful our scenario.

Appreciate the help!

Regards,

Sonia

[lbendlin]

"My Workspace is Premium Per User Capacity"

Sorry to hear that.

"Yeah scheduling MDX could be one approach but it will only validate my data no way it will let me know if my report is down"

At some point you will have to introspect and define what "my report is down"  means to you.  

- Power BI Service outage

- Capacity outage

- workspace corruption

- dataset corruption

- refresh failure

- unrecognizedETL logic issue

- users not being allowed to see visual

- visual not rendering due to memory constraints

etc etc.

A lot of these scenarios can be covered by running a MDX query.

Exporting a PNG successfully still doesn't tell you with absolute certainty that your report "works" - it can still show nonsensical data.

Sad as it is, your end users are still your best alert mechanism.

[lbendlin]

Are you on shared capacity or Premium? They use different calls.

Another alternative is to run MDX queries against your dataset with a scheduling tool of your choice.

[sonsh]

My Workspace is Premium Per User Capacity

Yeah scheduling MDX could be one approach but it will only validate my data no way it will let me know if my report is down 😞 

Thanks in Advance!

[lbendlin]

Use Power Automate to schedule report extracts (single page to PNG) every 15 minutes. If it fails, send notification.

[sonsh]

Already tried that getting below exception. working with support however. Any other suggestion?

[lbendlin]

Define "proactively"  - what is your SLA?  five minutes? fifteen minutes?

[sonsh]

Hi Ibendlin, Anything between 15 to 20 mins is good. So the goal is if the power bi report is down by any reason (i.e. fails to load or throws exception) within 15-20 mins i need an alert to be triggered for our team.

How can i achive it!

Hope this clarifies.

Thank you.