No optionto get HTML data from SharePoint

I can't import HTML Table data from Sharepoint to PowerQuery Dataflow. I've tried to import file in two ways and both faild. DO you ahve idea why ? Is there diffrent approach

1. Importing FIle via Web Page connector is not possible as it requires Gateway which does not allow to enter Organizational Account/is failing whne such is provided. So as I can't get authenticated, file is not accessible. On the other hand i.e. accessing PDF file on the same SP is supported as Gateway is not needed and Organizational account access supported - Why ?How to work around this ? or  alternativelly:

2. When using SharePoint Folder connector when I narrow down to exact file and click on Content Binary to get actual HTML for transformation I’m automatically redirected via PQ  wizard to steps:

   1. Navigation,
   2. Followed by Imported Web and then Imported Web returns Error: "The module named 'Html' has been disabled in this context"

      shared Query = let
        Source = SharePoint.Files("https://aaaa.sharepoint.com/teams/xxxxxx"),
        #"Filtered rows" = Table.SelectRows(Source, each ([Name] = "20191012.html")),
        Navigation = #"Filtered rows"{[#"Folder Path" = "https://aaaa.sharepoint.com/teams/xxxxxx/Shared Documents/999 Reporting/Opportunites/HTML/", Name = "20191012.html"]}[Content],
        #"Imported Web" = Web.Page(Navigation)
      in
        #"Imported Web";