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

Mail subscription depending on a Date of data loading

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! 

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Mail subscription depending on a Date of data loading

@AndreaSantest  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-...



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

Highlighted
Helper I
Helper I

Re: Mail subscription depending on a Date of data loading

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! 

Highlighted
Super User IV
Super User IV

Re: Mail subscription depending on a Date of data loading

@AndreaSantest 

 

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

This might be helpful in your scenario.



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

 

Highlighted
Community Support
Community Support

Re: Mail subscription depending on a Date of data loading

Hi @AndreaSantest ,

 

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

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

alert.PNG

ALERT EMAIL.PNG

 

 

Best Regards,

Icey

 

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

Highlighted
Helper I
Helper I

Re: Mail subscription depending on a Date of data loading

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 🙂 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors