Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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?
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
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
Dear Experts,
Kindly help as I have an urgent requirement.
Thanks in advance..
Best Regards
GS
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.