Mail subscription depending on a Date of data loading

[Anonymous]

Hi all, 

I have a doubt that i'm almost sure it's possible to do it, however I'm not able to find the solution. 

On my report, I have a table with a colum; date of load with only one row that it's modified each time somebody loads data on my model. 

This report, I have it published on a Power BI workspace and I want that each time this value change (for example if tomorrow somebody loads data it should change) it sends me an email. 

It this possible? 

Thanks! 

[nandukrishnavs]

@Anonymous  You can set the frequency as "After data refresh (once daily)"

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe#subscribe-to-a-dashboard-report-page-or-paginated-report

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Anonymous]

Thanks for you answer but this is not exactly what I'm looking for.. 

Imagine that I have a table: Date of load with one column with one row. 

Date of Load

05/15/2020

I can create a flag, for example, 

IF Date of Load = Today() --> 1

Else --> 0

So, what I need is to have an email when this flag is 0. Is this possible? 

Thanks! 

[Icey]

Hi @Anonymous ,

How about pin a card to dashboard and then set an alert. For example,

Measure = IF(MAX('Table'[Date of Load])=TODAY(),1,0)

Best Regards,

Icey

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

[Anonymous]

Hello @Icey , this is more or less what I'm looking for  but I would like to know if it's possible to implement it on a report, not in a dashboard. 

Thanks 🙂 

[nandukrishnavs]

@Anonymous 

Refer to this https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration#create-a-flow-that-uses-power-bi---from-a-template

This might be helpful in your scenario.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂