Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.