topic Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore in Service

Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Wed, 15 Feb 2017 09:56:07 GMT

Hi everyone,

I have a Power BI report that loads data from a bunch of files from a folder using the Folder data source. I am able to refresh it in Power BI Desktop but at the time of refreshing it, manual or automatic scheduled, I am getting the following error;

Cannot connect to the mashup data source. See error details for more information.
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

I have tested data souces in the Gateway section and all data sources are good to to go.

I have checked that

- Internet Explorer has Active Scripting enabled on the server where Enterprise Gateway is installed (image attached),

- https://*.powerbi.com is added in trusted sites

-Lastly, I am not running Personal & Enterprise gateway side by side, I have only Enterprise Gateway installed on the box.

Any ideas how to resolve this?

Thanks
Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Thu, 16 Feb 2017 07:59:55 GMT

Hi Anonymous,

You get the above error when refreshing data in Power BI Service, right? If so, do you restart Internet Explorer? If the issue still occurs after you restart IE, turn off any anti-virus software and verify that if there are any policies from your IT department blocking your access to information in data sources or Power BI in IE.

Also I would recommend you use other browsers such as Chrome, Firefox to sign in Power BI Service and check if you can refresh dataset successfully.

Thanks,
Lydia Zhang

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Thu, 16 Feb 2017 10:06:20 GMT

Hi Anonymous

Thanks for the reply. I am actually using Chrome, and get this error while I try to trigger a manual refresh in Power BI Service from Chrome. I have tried restarting Chrome, as well as my system. I have also tried to delete the dataset and subsequent reports and published the report, but no luck.

The screenshot of IE site settings, in my original post, was from the box where Enterprise Gateway is installed, and those settings are no different than my computer.

I'm going to check with IT if there are any controls though.

Thanks

Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Thu, 23 Feb 2017 02:03:39 GMT

Hi Anonymous

I had IT look at the connectivity between the machines, and there's no problem there. I am lost now

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Tue, 28 Feb 2017 07:49:48 GMT

Hi Anonymous,

Do you install the latest version of Power BI Gateway from this link: https://powerbi.microsoft.com/en-us/gateway/ ?

And do you get error when refreshing other datasets? What calculations are contained in this problem dataset? I would recommend you that delete this problem dataset and re-republish PBIX file to Power BI Service, then check if the issue still occurs.

Thanks,
Lydia Zhang

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Tue, 07 Mar 2017 05:37:36 GMT

Hi Anonymous

Thanks for the reply Lydia. I did try deleting and re-publishing the report & dataset, but that didn't resolve it for me.

Are you after specific types of calculations when you asked the type of calculations the report contain? It has lots of DAX driven calculations but that's about it. It doesn't have R scripts or anything else.

I tried installing the latest version of Power BI Data gateway on my server but the installation failed, probably because of the fact that our system administrator tred to upgrade the existing gateway which is the old, Enterprise Gateway. I'll get back to you once I am successful with gateway installation, however in the mean time, any help would be appcreciated.

Thanks
Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Wed, 08 Mar 2017 08:46:26 GMT

Hi Anonymous

I just noticed something, maybe nothing significant, but I thought I'll post it here for expert inputs. We have started to get a new error in our environment where scheduled data source in the Service fails to complete successfully giving an error "2 arguments were passed to a function which expects 1." Interesting, the error ID of this 2 arguments error is exactly the same as the error ID of "The Web.Page function requires Active Scripting to be enabled...".

Are they connected by any chance?

I am attaching the screenshot for review.

Thanks

Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Thu, 09 Mar 2017 08:35:21 GMT

Hi Anonymous

I have upgraded to the latest version of gateway and this problem still exists. any ideas how to resolve this?

Updated 9/3 1634:

Including log entries;

DM.EnterpriseGateway Error: 0 : 2017-03-09T08:10:56.4466393Z DM.EnterpriseGateway 92e76032-0685-4d59-8a35-a1c4b74d7c4b 35b60f3a-5dbb-ae98-fc35-6f770c13fd29 MGEA 1207b84d-5232-6511-7779-0ac379966677 1FB71038 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupValueException (0x80004005): 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.
at Microsoft.Data.Mashup.MashupResource.TranslateException(Exception exception)
at Microsoft.Data.Mashup.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1b.<>c__DisplayClass21.<<ExecuteAdoQuery>b__19>d__23.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__a`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2017-03-09T08:10:56.4466393Z DM.EnterpriseGateway 92e76032-0685-4d59-8a35-a1c4b74d7c4b 35b60f3a-5dbb-ae98-fc35-6f770c13fd29 MGEA 1207b84d-5232-6511-7779-0ac379966677 735E0535 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=192491, err=MashupValueException, rootcauseErrorEventId=0)

Thanks
Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Wed, 15 Mar 2017 09:30:52 GMT

Hi Anonymous,

I would like to suggest you to submit a support ticket:

Get support.

Thanks,
Lydia Zhang

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Tue, 21 Mar 2017 02:21:28 GMT

Hi Anonymous

Thanks for your reply, looks like you have given me MS Corporate Support link.

Updated 21/3/17. I'll go ahead and create a ticket with Power BI Support. It looks like it is a bug and comes into play when we are importing data from HTML files.

Thanks
Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Sat, 22 Apr 2017 08:29:02 GMT

Hi,

Is this really solved? I'm having the same issue. Have enabled Active Scripting as described but am still recieving the error. Data refresh is fine from PBI Desktop but not via the Gateway. Any other suggestions?

Joel

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Wed, 26 Apr 2017 19:13:25 GMT

We're having the same issue with our instance. Same exact error message.

One of our DataSets is coming from a webservice - using a TimeServer to get a correct time.

Would be nice to know how MS Support resolved the issue.

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

gemidriver — Fri, 27 Jul 2018 04:17:17 GMT

we are experiencing the issue with scheduled refresh / manual refresh getting data from html pages

the data is returned correctly with the power bi desktop software

but once published - fails to refresh

please help

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

TatianaLopez19 — Mon, 22 Oct 2018 16:03:46 GMT

Hola, estoy presentando el mismo error, pero al interntar ingresar parece que el tiket estuviera bloqueado :( :(.

Compartirias conmigo la solucion por favor.

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

sharryw — Wed, 27 Mar 2019 16:13:25 GMT

Hi guys, I had same issue as you guys, finally figure out what is going on,nothing about gateway version . if you need fix this , just also download powerbi desktop on gateway server, web data will refresh sucessfully.

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

hajoo125 — Thu, 13 Jun 2019 12:42:02 GMT

Hello,

I am having the same error on power BI desktop. I have a couple of reports pulling online from another service, all reports execute successfully except a new report that i am trying to pull in that contains thousands of data.

DataSource.Error: 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.
Details:
about:blank

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Wed, 04 Dec 2019 15:48:04 GMT

Did you ever get a workaround for this?

We just updated to the latest PowerBI Reporting Server and it seems we still have this issue with scheduling data refreshes for HTML files.

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

VitHorak — Thu, 02 Jan 2020 15:08:42 GMT

HI,

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

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

Anonymous — Fri, 03 Jan 2020 08:13:24 GMT

VitHorak

I can imaigne the frustration, and this issue was, and appears to still be very temperamental. I'd suggest try fiddling with your IE security zones and trusted website settings.

As far as I can recall. I was playing with IE settings until one fine morning the issue disappeared, on its own.

Sorry, not much of a help.

Thanks

Kaz

Re: Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore

VitHorak — Fri, 03 Jan 2020 08:37:10 GMT

Anonymous

Hi. Thank you for your post. Yes, it is very frustration because sometimes refresh proceed successful but usually not.

Do you think that your problem could be solved by some updates from Power BI side instead of IE settings?

I tried few changes in IE scripting setting but it seems, that this changes do not affect successful refreshes.

I have 3 datasources in Power BI Desktop. After couple of transformations I UNION them in one big table. When I try "actualize all" in Power BI Desktop it usually ends with Active scripting error. But when I try to actualize data sources separetly one by one, this process is much more successful! But I really absolutely don't understand why and still this is not 100% successful proces!

Thank you!

EDIT 2020-01-03:

It seems that the problem can be in to many rows and columns in web table.... But I am just guessing 😞

I am going to make some changes in web data source to decrease number of rows to import in Power BI Desktop...