Forum Discussion

vyny17's avatar
vyny17
Frequent Visitor
4 years ago

Send e-mail report everyday automatically based on condition

Hi there, Power BI  specialists and enthusiasts!

Here is the thing, I have a table that indicates the payment status (if it is delayed or not) of some services made by the company I work for 

the status is based on the billing day and on a deadline for payment (in terms of days)

 

There are four types of status:

  • Billing made
  • Payment received
  • Billing delayed
  • Payment delayed

The point is: I want Power BI to generate every day a report listing all the payments and billing delayed, sending it directly to the managers responsible.

 

The columns are already calculated and working fine, I just want the daily report automatically generated and sent everyday

 

I've been doing researches about that subject but didn't find anything that seemed like my problem.

If you could help me, I'd thank a lot!!!