When I open HTML file store on my local computer it shows it shows in a different way in the power query and when I open the same HTML file stored on the SharePoint folder then it shows in a different way.
Below are screenshots
1. When stored on my C Drive
2. Details of file when in C Drive
3. Imported HTML when on C Drive
4. When stored on Sharepoint folder
5. Details of file when in Sharepoint folder
6. Imported HTML when in sharepoint folder
1.
2.
3.
4.
remaining Screenshots uploaded as attachment.
mmbr1606
9
Super User 2025 Season 1
stampcoin
7
SD-13050734-0
6