Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Web.Contents failing refresh

Hello,

 

I am unable to refresh a dataset once published to the Power BI service, and my query does not contain any dynamic references. It is simply:

 

Source = Xml.Tables(Web.Contents("ftp://ftp.bom.gov.au/anon/gen/fwo/IDN11060.xml")),

 

I am not sure why this is failing - the credentials are anonymous and there is nothing dynamic in the URL?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Maggie,

     

    There is no need for an on premises gateway with Web.Contents as it is connecting to all sources in the cloud.

     

    I have fixed the problem by changing the Web.Contents method to connect to a HTTP instead of an FTP source.

    It appears the issue lies solely with connecting to FTP contents.

     

     

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    Do you use a on premises gateway?

    It seems when connecting with the web connector, it would need on premises gateway to refresh successfully.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Maggie,

       

      There is no need for an on premises gateway with Web.Contents as it is connecting to all sources in the cloud.

       

      I have fixed the problem by changing the Web.Contents method to connect to a HTTP instead of an FTP source.

      It appears the issue lies solely with connecting to FTP contents.

       

       

      • martigas's avatar
        martigas
        Frequent Visitor
        6 years ago
        Hello
        I currently have this problem, could you explain in detail how you solved it?