Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to access some data stored in O365 sharepoint using a dataflow. The query works fine in the desktop but will not refresh in a dataflow due to the error in the title. It is not possible to use a gateway as a workaround since there is no enterprise gateway connector for Sharepoint online. https://community.powerbi.com/t5/Service/DataFlow-error-The-module-named-HTML-has-been-disabled-in-t...
The error occurs when trying to apply the Web.Page function to a column containing HTML text in the dataflow editor. the query is shown below and produces no errors in the Feb 2019 desktop client
Source = SharePoint.Files("https://sharepoint.com", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "https://sharepoint.com/teams/SAP Data/P Numbers/")),
#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Text.FromBinary([Content])),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Web.Page([Custom])),
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.