Web Connection - HTML Table - Scheduled Refresh problems (without Gateway)

[power2data]

Dear All,

I am using Web Connector from Power Bi Desktop, and all is ok when i refresh data from Power Bi Desktop:

Origin = Web.BrowserContents("https://www.website.info/page"),
#"Table from HTML" = Html.Table(Origin, {{"Column1", "TABLE[id='main_ta....

Web connection is configured with Anonymous Users (website does not requires any authentication) and I have tried with any kind of privacy setting.

The PROBLEM is:

I have published the report on web (using embed code)  and I would that it refresh automatically (every 24 hours) without using Gateway (it requires to have my PC running, or there is another solution?)

Is there any limitation about refresh web data based on HTML table?

Or is there a know issue of usage of Web.BrowserContents or anonymous authentication?

I have a similar Report based on web csv (with authentication) and It works perfectly.

Origine = Csv.Document(Web.Contents("https://website....

Any help in resolving this issue or workaround is appricated,

Also let me know if any further details are required.

Tony.

[v-yingjl]

Hi @power2data ,

When you publish to web using embed code, please note:

Updates to reports, and data refresh

After you create your Publish to web embed code and share it, the report is updated with any changes you make, and the embed code link is immediately active. Anyone who opens the link can view it. After the initial creation, updates to reports or visuals may take up to two hours before your users see them. The data is cached for one hour from the time it is retrieved. We don’t recommend using Publish to web for data that needs to refresh frequently. To learn more, see the How it works section later in this article.

Data refresh

Data refreshes are automatically reflected in your embedded report or visual. It can take up to two hours for refreshed data to be visible from embed codes. To disable automatic refresh, select don't refresh on the schedule for the dataset the report uses.

If you want it refresh daily automatically, just configure scheduled refresh for it.

"Is there any limitation about refresh web data based on HTML table?

Or is there a know issue of usage of Web.BrowserContents or anonymous authentication?"

As far as I know, there seems no special limitations ot known issues about it, I have tested it in my environment using web connector with anonymous authentication and it works fine.

Best Regards,
Yingjie Li

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