Get Data from Email

[DerekCM]

I am trying to pull the data from a daily email and the html code keeps getting truncated when I expand the body in Power Query.

The email that I am connecting to has sales data in tables within the body of the email. I was hoping that there would be a way to parse the html code in Power Query so that I just get the data from the tables in the email. Instead, when I connect to the email and expand the "htmlBody" the html is truncated and I can't do any transformation to it at all.

How can I access the information within the email from PowerQuery so that I can extract the key data elements and put them in a table?  Thanks in advance for your help! 

Excerpt from email (actual numbers have been redacted).

[Anonymous]

Hi @DerekCM ,

Try add a custom column instead of expand columns:

= [Body][HtmlBody]

When expand:

Some data were missing.

If this doesn't work, consider posting examples and expected output.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group