Combining email data with attachment data

[Kanivan]

I have linked Power BI to a folder in Outlook where I receive emails with attachments. The attachements have the same format. for example

Email1 (Sender a@aa.com, time received 15 Nov 2019 11:02am , Attachment 1:
Head1|Head2|Head3
1             |2           |4
5             |2           |5

Email2 (Sender b@bb.com, time received 16 Nov 2019 10:15am , Attachment 2:
Head1|Head2|Head3
4            |7             |2



I have setup the Query editor so that the attachments in the folders are combined:
Head1|Head2|Head3

1            |2             |4
5            |2             |5
4            |7             |2

Is there a way to have the sender and time received to every row in the combined attachment table:
Head1|Head2|Head3|Sender|TimeRec

1            |2            |4             |a@aa.com|15 Nov 2019 11:02am

5            |2            |5             |a@aa.com|15 Nov 2019 11:02am
4            |7            |2             |b@bb.com|16 Nov 2019 10:15am

[v-xuding-msft]

Hi @Kanivan ,

You could connect Microsoft Exchange Online into Power BI to get the name and email address. And then append them to your existing table.

• Get data > Choose Microsoft Exchange Online

• Sign in Microsoft account

• Choose Mail table > Transform data
• Expend Sender column to show address

• Just retain the columns of address and received datetime

Then you could add columns or append the queries based on your actual data model to implement.

Best Regards,

Xue Ding

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

[Kanivan]

hi Xue Ding, thank you for your reply. Unfortunately this doesnt solve my issue. Once I choose Combine - Attachment content, a new table is created with the attachment information and the original email information dissapears. So I cant refer to the sender email column etc. Is there a way to do this.