Emails from Exchange Online: entire email body not available?

[OneWithQuestion]

Looking a emails from Exchange Online, one of the columns is Body (as a record).  When I expand and split out the TextBody property of the Body column, I note that the entire message does not load into TextBody.  The same for HtmlBody.

Is there a data limit or character limit on how much is returned?

[EllaScott]

Very interesting idea! I second it.In my student life, when studying takes up most of my time, I recommend using a tool that can free up at least some time for more direct communication. PaperWriter boasts a team of seasoned professionals https://paperwriter.com/write-my-discussion-board-post  with diverse academic backgrounds. From literature to engineering, there's an expert available for every subject matter.

[sdshiyalwala]

Less than 2,000 characters but still not fully loaded on power BI query only few. I have searched all the online and there is no solution found by me. Tnx....

[v-yuezhe-msft · Accepted solution]

@OneWithQuestion,

Do you mean that the characters in a cell ? In Query Editor, the cell will not show all characters, when you apply changes to report view and drag the textbody column to a table visual, you should discover that it shows more characters, but it can't be longer than 32,767 characters.

Regards,
Lydia

[Anonymous]

Hello, I am using power query and am not sure what the "report view" is. I don't think that is an option on power query. 

I am trying to load the entire Text Body in Power Query Editor, then replace portions of text with a symbol, then split the column by that symbol to create multiple columns with the values that I am looking for. Is this possible?