Forum Discussion
Scheduling error - The Web.Page function requires Active Scripting to be enabled in Internet Explore
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
IE settings for Active Scripting
- Anonymous9 years ago
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
22 Replies
- AnonymousNot applicable
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- AnonymousNot applicable
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- AnonymousNot applicable
Hi Anonymous
I had IT look at the connectivity between the machines, and there's no problem there. I am lost now
- sharrywNew Member
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.
- hajoo125Frequent Visitor
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
- VitHorakHelper I
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.
- AnonymousNot applicable
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.
ThanksKaz
- VitHorakHelper I
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...
- VitHorakHelper I
It's weird... In Power BI Desktop app anytime while I actualize data source one by one all of datasources actualization end with succes. When I click on Refresh in upper menu and the actualization of all data sources start, the proces fail with Active scripting error.
Much more stranger is, that after one by one actualization is finished with success when I click on Refresh (upper menu), the process of actualization all of data sources in one step finish with success!!!
Weird proces:
1. step: click on Refresh in Power BI Desktop (upper menu) - failed with Active scripting error
2. step: click on Refresh data in specific data source (Fields menu - right clck on data source) - finish with sucess
3. step: click on Refresh in Power BI Desktop (upper menu) again - actualization of all data sources finish with sucess !!!!!!
It must be some kind of bug!
- AnonymousNot applicable
VitHorak it is a bug, a kind of king bug :). Interestingly, the age old remedy of restarting the application also does not work. To me, that's a bigger bug :).