Extract HTML Emails

Hi AZJohnPowerBI 

It seems that you want to extract data from HTML emails and use it in Power BI. However, the default method of importing data from Microsoft Exchange does not parse the HTML content properly. To solve this problem, you have two options:

Use a Power Query function to parse the HTML content. You can use the Web.Page function to convert the HTML content into a table. To do this, you need to add a custom column in Power Query Editor, and use this formula:

web.page()

Web.Page - PowerQuery M | Microsoft Learn

This will create a new column with a table value for each email. You can then expand the table and select the columns you want to keep. You may need to do some further transformations to clean up the data.

Use a third-party HTML parser to extract the data. There are some online tools that can parse HTML data and convert it into CSV or JSON format. For example, you can use Zebra BI or ParseHub to parse HTML data. You can then import the CSV or JSON file into Power BI using the Get Data option.

Regards,

Nono Chen

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