Getting full body text from email with lines in separate rows

[tsibilski]

Hi, 

I'm trying to get full body text from email imported to Power BI by Exchange functionality with each line in a separate row.

All I can get only one row extending Body to (TextBody).

What I need is what I could get saving the message and opening it in Notepad.

Any tips? 

[v-rongtiep-msft]

Hi @tsibilski ,

What is your problem? Can you open pbix in Notepad? It seems you can only open pbix in Power BI Desktop.

If there is any question in handle data, please provide a screenshot and expected output.

Best Regards

Community Support Team _ Polly

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

[tsibilski]

Split by Delimiter, by character None, Into Rows, using Special Characters, Line Feed 😄