Forum Discussion

Marco3007's avatar
Marco3007
Frequent Visitor
7 years ago
Solved

Updating data source by replacing Outlook attachment

Hi! This may be an amateur's question (which I am, have started recently...), but for me it is tricky:   I have a scheduled report sent to me by e-mail, from which I only need the Excel attachment....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    In your dataset, I am assuming that there is a column which represents "Date of Attachment" or Date of Mail".  In the Query Editor, write this "M" language formula to get today's date in a column

    =DateTime.Date(DateTime.LocalNow())

    In "M" itself, write this formula to check for whether the Date of Attachment is the same as Today's date

    =[Date of Attachment]=[Today]

    Today is the name of column with Today's date.  Filter this new column on TRUE.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

As mentioned in my previous message, there has to be a Date of Attachment or Date of Mail column there.

Marco3007's avatar
Marco3007
Frequent Visitor
7 years ago

After banging my head a little, I found what I was looking for – which is to keep only the latest e-mail: I just had to use the option "Keep Rows" and select 1, so out of the incoming e-mails flow, Power BI will only stick to the last one received.

But thank you very much for your time, Ashish!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    You are welcome.