Forum Discussion

PhilC's avatar
PhilC
Resolver I
7 years ago

DataFlow error - The module named 'HTML' has been disabled in this context

Hi, receiving the above HTML error when creating an entity.  See below for screen capture of two different error messages for two entities (queries).

 

There are a number of other entities that are being used in the ones failing, mostly functions that provide the build up of a URL to use. 

 

The source is our organisation's web server that pulls back reports from an Oracle database.  The web server is visible to the outside, but does require credentials.  Have used Basic credentials for access.

 

The queries have been copied from ones working in Power BI Desktop.

These are the error messages from two different entities

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks for any thoughts on how to troubleshoot this one.

 

Cheers

Phil

Dataflow
Need Help

6 Replies

  • Galia's avatar
    Galia
    Microsoft Employee
    7 years ago

    Hi Phil,

     

    I've forward the issue to dataflow engineering team.

    We will get back to you once we will find the issue.

     

    Thanks,

    Galia

    • Yovav's avatar
      Yovav
      New Member
      7 years ago

      Hi Phil, 

       

      To further understand the issue, can you please elaborate on the origin of this error message?

      Is it showing inisde the queries editor window, or does it appear after closing it?

       

      Thanks,

      yovav

      • PhilC's avatar
        PhilC
        Resolver I
        7 years ago

        Hi Yovav

         

        The error occurs in the Query editing  area,  when  the preview would normally be returned.

         

        I'll be out of the office until Tues (Australian time), so probably cannot provide any further info until then.

         

        Noting also, the DataFlow cannot be saved yet, have an error message and have a Support ticket opened - 119020719638642).  I have not navigated away from the dataflow yet in the hop that I do not have to redo all the queries in the dataflow.

         

        In case it is of use:

        - as noted above the query used a number of functions to create a URL and bring back the information

        - as a test, I tried to hard code the URL in a new query and use that, was not able to do it using Web or Web API tiles in the data sources.  Received a message that need a Gateway to use Web source

        - Installed the On Premises Gateway, but it does not say personal, so might not have installed correctly

        - IN further testing, the hard coded query will not accept my credential (using Basic).

         

        Not sure if this is relevant but providing as much info as possible.

         

        Cheers

        Phil

         

        Cheers

        Phil

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi PhilC,

       

      A workaround for you:

      -Go to the dataflow settings

      -Click add to gateway, then click add

      -Pick the gateway select Apply

       

       This should resolve the issue.

       

      Regards,

      Frank

      • PhilC's avatar
        PhilC
        Resolver I
        7 years ago

        Hi Frank (v-frfei-msft),

         

        Where do I find Settings for the Dataflow?  Remember, I have yet to be able to save it.  Only place I can see it Options when I am in Edit Queries.  This gives a drop down selector for On-premises gateway, however my personal gateway is not appearing in the drop down to select.  We do not have an enterprise gateway at this stage.

         

        Update: now realise data flows can only use enterprise gateways, not personal ones. 

         

        Based on us not having an enterprise gateway, is there any ability to use data flows at this time?

         

         

        Cheers

        Phil