Use an .mht file in Power Bi

[Aria89]

Hi all! If someone could help with the situation described below, that would be great. 

I have a scheduled report which is sent to my email but it is in .mht format. If I select to open it with Excel, it opens properly, data are structured properly etc. 

Also, I am creating a Power Automate flow that takes this attachment when it arrives to my email and saves it on SharePoint. 

This file needs to be used in Power Bi as a datasource, but I cannot do that due to the .mht format. 

Is there a way that I can automatically convert the .mht file to an acceptable format (csv, xlsx etc), so that it can be used in Power Bi?

Thanks a lot. 

[Anonymous]

Hi @Aria89 ,
As you've noticed, Power BI does not natively support .mht files. However, we can work around this by automating the conversion of .mht files to a format that is compatible with Power BI, such as CSV or XLSX.
You mentioned that you can use excel to open the file up and you can try to save the file as .xlxs, if this doesn't work,you would need to find a third-party connector or service that can perform this action.

Best regards

Albert He

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

[Aria89]

Thanks a lot for the response. 

Could you please suggest a way of automating the conversion?

Thanks