cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FaizRahman
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION

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.

View solution in original post

7 REPLIES 7
VitHorak
Frequent Visitor

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

v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

@FaizRahman ,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 ?

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.

View solution in original post

 

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?

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors