cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ganeshpss Frequent Visitor
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

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

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. 

 

w3.PNGw4.PNGw5.PNG

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Ganeshpss Frequent Visitor
Frequent Visitor

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

Dear Experts,

 

Kindly help as I have an urgent requirement.

 

Thanks in advance..

 

Best Regards

GS

Moderator v-qiuyu-msft
Moderator

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

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. 

 

w3.PNGw4.PNGw5.PNG

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Josh_BI_UK Regular Visitor
Regular Visitor

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

 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