Web.Contents failing refresh

[Anonymous]

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?

[v-juanli-msft]

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 · Accepted solution]

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]

Hello

I currently have this problem, could you explain in detail how you solved it?