PowerBI - Get data from Exchange- Inbox details(size of the mail,attachments etc

[Ganeshpss]

Hi,

I'm trying to integrate my outlook mail box with power bi. However, I couldnt find the size of email & number of attachments etc.

What's the best approach to integrate with microsoft exchange? Currently, I'm using exchange connector.

The table called mail just have the folder path and unique id for each email. However, I couldnt find the email size and number of attachement.

Could someone please help me with your inputs?

Thanks
Ganesh

[Swapn22]

Hi There,

Thank you for the process to get the size , I am wondering if the Size (Field in the attribute for Email) will be in KB correct?

[v-qiuyu-msft · Accepted solution]

Hi @Ganeshpss,

Based on my test, the Exchange online data source in Power BI desktop can retrieve data about the attachments and size. When you select the mail table, please click Edit go to Query Editor. You can find the column named Attachments and Attributes, please expand contained columns. 

Best Regards,
Qiuyun Yu 

[Josh_BI_UK]

 Hi Qiuyun (@v-qiuyu-msft ),

Would you happen to know what data size multiple the attachment size column is in.

I have an attachment size that is: 38222 . When I look for the email in my mail box it says the mail is 107 KB?

I have

[Ganeshpss]

Dear Experts,

Kindly help as I have an urgent requirement.

Thanks in advance..

Best Regards

GS