Forum Discussion

FaizRahman's avatar
FaizRahman
Frequent Visitor
7 years ago
Solved

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...
Need Help
  • FaizRahman's avatar
    FaizRahman
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • FaizRahman's avatar
    FaizRahman
    Frequent Visitor
    7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      FaizRahman ,

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

      Regards,
      Lydia

      • FaizRahman's avatar
        FaizRahman
        Frequent Visitor
        7 years ago

        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 ?