Extract data from 100,000 HTML files

[sayedatris]

Need your help to extract data from HTML files.

every day I received around 250 HTML files or around 100,000 files per year. 

each day has a folder that containers around 250 files.

Is there a way to pull data from this large HTML database.

regards 

[Icey · Accepted solution]

Hi @sayedatris ,

Can what @Greg_Deckler mentioned meet your requirements?

You can refer to this document: Combine files (binaries) in Power BI Desktop.

Best Regards,

Icey

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

[Greg_Deckler]

@sayedatris - In theory you could use a Folder query and Combine Binaries.