Get data from htm file to Power BI

Hi Anonymous 

You could refer to the second method in this article: Web Scraping 1: Combine multiple tables from one page in Power BI and Power Query – The BIccountant

Or in your screenshot, you could try right-clicking on HTML Tables [8]. If a menu pops up having "Transform Data", you could click on "Transform Data". Then you will enter PQ and see the Source step which lists all tables there. (The right-click menu doesn't always display when PQ chooses different connector functions. In that case, you can try the method in next paragraph.)

If your Source step doesn't display a table containing all tables but displays HTML codes like below. Replace its original connector function Web.BrowserContents with Web.Page(Web.Contents(url)). This will change output format. 

Once your Source step has all tables in the webpage, you can filter rows to only keep the tables you want. Then expand Data column to have all data in one query.  

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.