topic Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer in Power Query

The Web.Page function requires Active Scripting to be enabled in Internet Explorer

FaizRahman — Mon, 25 Feb 2019 14:10:43 GMT

I have a webquery and Analysis services which I am using to bring in the data. The refresh is working fine when configured using my personal gateway, but when I try to refresh it using the enterprise gateway, I get the below error:

Underlying error message: The Web.Page function requires Active Scripting to be enabled in Internet Explorer options. See https://go.microsoft.com/fwlink/?LinkId=506565 for details on how to enable Active Scripting.

DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

I have checked and Active Scripting is enabled on the machine where enterprise gateway is hosted. Can you please help me sort this out.

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

Anonymous — Tue, 26 Feb 2019 06:08:05 GMT

FaizRahman ,

What Power query code do you use to connect to the web data source in Power BI Desktop? Is there any possibility that you use Web.Contents() function instead of Web.Page() function to get data?

Regards,
Lydia

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

FaizRahman — Tue, 26 Feb 2019 11:21:35 GMT

I am using Web.Page() function to fetch data using NetSuite API into Power BI.

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

Anonymous — Fri, 01 Mar 2019 07:34:47 GMT

FaizRahman ,

Is there any possibility that you use Web.Contents() function instead of Web.Page() function to get data?

Regards,
Lydia

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

FaizRahman — Mon, 04 Mar 2019 07:16:10 GMT

My query is something like this:

Source = Web.Page(Web.Contents("URL HERE")),
Data0 = Source{0}[Data],

How do you suggest I should edit it ?

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

FaizRahman — Thu, 07 Mar 2019 10:24:11 GMT

We were able to solve the issue. The issues was Local Group Policy was blocking the service user(pbiegwservice) to use Active Scripting.

* From the Windows Server Start menu, open the Local Group Policy Editor (gpedit.msc).
* Under Local Computer Policy, expand Computer Configuration > Administrative Templates > Windows Components > Internet Explorer > Internet Control Panel > Security Page > Internet Zone.
* Right-click Allow active scripting and click Edit.
* In the Allow active scripting dialog, click Enabled.
* In the Options area, select Enable from the list.

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

hajoo125 — Thu, 28 Nov 2019 14:06:58 GMT

This soultion doesn't work for me. Active scripting is already enabled on my device and i am using the syntax below on PBI desktop:

let
Source = Web.Page(Binary.Buffer(Web.Contents("COMMCARE_DATA_FEED")))
in
Source

Can someone please assist?

Re: The Web.Page function requires Active Scripting to be enabled in Internet Explorer

VitHorak — Mon, 02 Mar 2020 08:53:33 GMT

Hi,

same problem, but answer marked as solution above does not help.

I have web site (google sheet as https) as data source with approx 8k rows and 25 columns. In Power BI Desktop and in Power BI Services on web (via on-premise PBI gateway) is the same problem. Sometimes refreshing data from this web finish with sucess but usually failed because the Active scripting error. But active scripting is enabled in IE on my PC as well as on server, where the gateway service is running. We have latest gateway, latest desktop app installed ....

I don't understand why sometimes the same datasource in the same report refreshed smoothly and sometimes failed!!!

Thanks for any suggestions.

EDIT 2020-03-02

After latest update of Power BI Desktop app and Gateway, it seems that whole proces goes smoothly...