Setup Alerts for new records daily

[DeBIe]

Hi All,

I have a table with for example 5 records that represent invoices. I would like to receive a daily alert IF the count of total records is more than the previous day. 

I believe I need to create the below measures

• [Total Today]: Calculate Total Invoices, Filter date(today)
• [Total Yesterday]: Calculate Total Invoices, Filter date(today-1)
• [IsMoreInvoicesToday]: IF [Total Today] > [Total Yesterday], 1,0
• [IsMoreInvoicesTodaySum]: Sum[IsMoreInvoicesToday]

I think I could use the card type visual for my measure [IsMoreInvoicesToday] and then enable alert with threshold if greater then 0.

What do you guys think, is my idea of implementing this any logic?

Thank you for your help.

[DeBIe]

Hi all again. The company decided that it is not needed to receive an alert when a new record is added.  For now, every record that is in the dashboard is a sign of an alert. Which means that it is a simple count of the records and if >0 then send alert.

I've also been able to automate this process with power automate. I am able to send an alert to several e-mail adresses (no premium feature). One question tho, I have like 15 different Stored Procedures with different output-data. This means it could be possible that in a day there will be 15 alerts send to the mail addresses. Is there a way to gather all alerts in just one mail instead of 15 separate?

Thanks for the help

[DeBIe]

Hey @selimovd @AllisonKennedy ,

I do have one more question. I have to set up these alerts for 10 separate stored procedures. Now I noticed that not all SP's have a date field that I can use to add to my measures. They have for example invoice date columns, but that is not representable for my measure. Is there another way to write similar measures if there is not a date field available? Or is that not possible?

Maybe that will be the reason for me to have a look at setting up triggering in the SQL database itself as you mentioned.

[AllisonKennedy]

@DeBIe This seems logical to me. Let us know how it works! 🙂 

[selimovd]

Hey @DeBIe ,

yes, that's the way to go.

If for example your data source is SQL Server, you could also do the altering with Power Automate and SQL Server:

Replace Power BI Alerts with Power Automate Alerts for SQL Server Data — ehansalytics

In general you can trigger further actions once an alert is happening with Power Automate:

Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[DeBIe]

Hey @selimovd 

I was reading the article Replace Power BI Alerts with Power Automate Alerts for SQL Server Data — ehansalytics but I found out that it's a premium feature (step 2 in the article)? For me, this is not an option at the moment. 

I haven't checked yet but your second-mentioned article will also only be available for premium?

I'll give it a try with my own suggested solution. Thank you for your validation and other tips @AllisonKennedy  & @selimovd 

[selimovd]

Hey @DeBIe ,

no, the second approach doesn't use Power BI. It will check the data right in the source, for example if that is SQL Server.

If the value is more than yesterday you could send an alert. But actually Power BI is not really involved. Just wanted to give you a out-of-the-box-idea 😉

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[DeBIe]

Hey @selimovd,

Thanks for clearing that up. That would also be a possibility, I'll have to check this with the person who delivers me the data through SQL. For now, I am going to give it a try with my own suggested solution and will keep you updated on the process.