refresh data using web.contents source

[leewsimpson]

I have a simple desktop report that uses web.contents: (the auth is included in the URL)

let
Source = Web.Page(Web.Contents("https://syste<removed>9O5jbf8vzwfh_jxw")),
Data0 = Source{0}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Data0, [PromoteAllScalars=true]),  .. etc

This works wonderfully locally.  When I publish it, I am unable to refresh from the web.

The Dataset schedle refresh seems to insist on a local gateway.  No direct option is available.  

Any workarounds?  (except having a local PC with a gateway to proxy the traffic)

Lee

[v-jiascu-msft]

 @leewsimpson,

Hi Lee,

It seems a gateway is needed according to this document. You can update the credentials in the settings for now. Maybe some professionals have a wonderful workaround.

Best Regards!

Dale