Forum Discussion
Web.Page() gives Active Scripting Error when trying to process large Rich Text files
It's all in the title, really.
I am trying to load a series of tabular files in Rich Text, using the Web.Page() function to parse the content. Small files, no problem. Once it gets to about 30MB, starts telling me I need to enable Active Scripting in IE. IE has active scripting enabled so it doesn't make a lot of sense to me.
let
Source = Web.Page(Parameter1),
Data1 = Source{1}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Data1, [PromoteAllScalars=true])
in
#"Promoted Headers"
"Parameter1" is the table element that I am interested in.
Googling around this seems like a known issue, but there's not really any explanation or workaround.
Can anyone suggest an alternative way to parse this data?
Happy to dig into the tags and pull the table out manually, but I am not good enough with M to write the script.
Not easily, sorry.
I resolved the issue by reconfiguring my M query to use Html.Table() instead of Web.Page() to get the data out. I believe the original query may have been written before Html.Table() was available.
An answer would probably still be useful for this question as I believe Html.Table() is not available in Power Query for Excel (so I am sure an Excel user will come looking at some point).
2 Replies
Can you post a sanitized version of such a large RTF ?
Not easily, sorry.
I resolved the issue by reconfiguring my M query to use Html.Table() instead of Web.Page() to get the data out. I believe the original query may have been written before Html.Table() was available.
An answer would probably still be useful for this question as I believe Html.Table() is not available in Power Query for Excel (so I am sure an Excel user will come looking at some point).
