Forum Discussion

sdshiyalwala's avatar
sdshiyalwala
Frequent Visitor
2 years ago
Solved

How many rows will be loaded against single mail

Dear Experts,   At the outset thank everyone for this learing forum, I have one query on Power BI where data is via Outlook where in Inbox I have around 2,000 mails. While uploading into Power BI r...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sdshiyalwala 

    After testing, if you connect to the mail table, when you receive one email, it will return one row in power BI.but in the row it will contain multiple columns that with different data types, such as list and table. it means the emails contain not just the body of the message, but also metadata such as sender information, recipient information,attachments and so on.

     

     

     

    So when you upload the emails the related content will both be uploaded, so the times of uploading will be more than the counts of the email.

     

    Best Regards!

    Yolo Zhu

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