Schedule refresh when the source is web.browsercontents?

[Yash48]

Hi Guys, Can you please help me how I can Schedule refresh when the source is the below line in quotations. I just loaded a webpage (.html) file in power BI and published it. But I am not able to schedule refresh it. I know that I can do it using gateway, but I want to do it without one. Is there a way for me to do this?

Also, I tried using Web.Contents, but I am not getting the tables data when I use Web.Contents, but I am getting the tables data when I use Web. BrowserContents

"= Web.BrowserContents("https://www.taipower.com.tw/d006/loadGraph/loadGraph/genshx_.html")"

Thank you

[Anonymous · Accepted solution]

Hi  @Yash48 ,

According to this webpage: Web data sources require a gateway to refresh data.

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Regarding Web.Contents and Web.BrowserContents, you can check the following link:

https://community.powerbi.com/t5/Power-Query/No-content-with-Web-Contents-vs-Web-BrowserContents/td-...

https://community.powerbi.com/t5/Service/Web-Contents-is-not-working-with-Scheduled-Refresh-BUG/m-p/...

https://docs.microsoft.com/en-us/power-query/web.contents

Best Regards,

Liu Yang

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