cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tyr Helper I
Helper I

Online monitoring for reports with personalized metrics

Hello there,

 

I use usage metrics in default but I am in different need.

I want to create alarms or identifications for reports if they are working properly or not, automatically.

 

For example is it possible to create a special metric for report(for example rowcount should be greater than 0, volume should be greater than 0, etc.) and refresh it automatically and send alert/email/message when these requirements don't meet.

 

I have lots of reports in organization and maintaining them one by one is really time consuming. 

 

Is there any best practices or methods do you use?

Do you have any suggestions?

 

Thanks a lot!

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ranbeermakin Resolver II
Resolver II

Re: Online monitoring for reports with personalized metrics

Hi @tyr 

 

Good question on managing multiple alerts in reports. It actually boils down to number of datasets you have/you are worried about.

 

There are couple of approaches to tackle this:

 

1. For each dataset you can create a "Quality Metrics" Report. Put the quality metrics (rowcount, volume etc.) in a table with conditional formatting. Format cells in red if value =0 else green. Subscribe to these reports so you receive emails when data refreshes. You will see some of your cells red if any of the metrics are violated.

 

2. Another approach is to pin these quality metrics to a dashboard and then set alerts in the dashboard. The only caveat is you will receive emails for every alerts (set for every singly quality metric). You may be able to manage these multiple alerts using Power Automate and push to a database. You can then run another Power Automate every 1 hour to pickup these alerts and send you a  consolidated email. You need to check how to do this.

 

All the best

Ranbeer

 

View solution in original post

2 REPLIES 2
Community Support
Community Support

Re: Online monitoring for reports with personalized metrics

Hi @tyr ,

For the specific reports, you could reference the blog: Usage Metrics or Do It Yourself Power BI Monitoring Report  to have a try. And you could take a look at the document:Data alerts in the Power BI service  to set alerts for the card visuals.

For now, there is not a good idea to implement for lots of reports at a time. We only can create and set alerts one by one.

 

Monitor usage metrics for Power BI dashboards and reports 

Monitor usage metrics in the new workspace experience 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ranbeermakin Resolver II
Resolver II

Re: Online monitoring for reports with personalized metrics

Hi @tyr 

 

Good question on managing multiple alerts in reports. It actually boils down to number of datasets you have/you are worried about.

 

There are couple of approaches to tackle this:

 

1. For each dataset you can create a "Quality Metrics" Report. Put the quality metrics (rowcount, volume etc.) in a table with conditional formatting. Format cells in red if value =0 else green. Subscribe to these reports so you receive emails when data refreshes. You will see some of your cells red if any of the metrics are violated.

 

2. Another approach is to pin these quality metrics to a dashboard and then set alerts in the dashboard. The only caveat is you will receive emails for every alerts (set for every singly quality metric). You may be able to manage these multiple alerts using Power Automate and push to a database. You can then run another Power Automate every 1 hour to pickup these alerts and send you a  consolidated email. You need to check how to do this.

 

All the best

Ranbeer

 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.