Showing results for 
Search instead for 
Did you mean: 
leewsimpson Frequent Visitor
Frequent Visitor

refresh data using web.contents source

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


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)



v-jiascu-msft Super Contributor
Super Contributor

Re: refresh data using web.contents source



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!


Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,049 guests
Please welcome our newest community members: