cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ganeshpss
New Member

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
v-qiuyu-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

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.

View solution in original post

 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
New Member

Dear Experts,

 

Kindly help as I have an urgent requirement.

 

Thanks in advance..

 

Best Regards

GS

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Kudoed Authors