No optionto get HTML data from SharePoint

[wojtek7]

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";

[dax]

Hi wojtek7,

If you connec to sharepoint online folder (because this is cloud datasource, gateway is used to connect on-primise datasoure from cloud service), you don't need gateway.

In addition, I test this in my environment, I have the same experience as you, I am not sure whether this is caused by dataflow, I suggest you could create ticket for this problem.

Best Regards,
Zoe Zhi

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