Forum Discussion

Ascalon's avatar
Ascalon
Regular Visitor
5 years ago
Solved

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, st...
Need Help
  • Ascalon's avatar
    Ascalon
    4 years ago

    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).

lbendlin's avatar
lbendlin
Super User
4 years ago

Can you post a sanitized version of such a large RTF ?

Ascalon's avatar
Ascalon
Regular Visitor
4 years ago

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).