Refreshing Data Connected to Website

Anonymous · ‎08-26-2019

Hi,

I have a report on the Power BI Service that uses a website scrape as a data source. This website data changes frequenly and I want it to reflect those changes in my shared reports/dashboards. However, when I hit refresh in the Power BI Service, nothing changes. If I refresh it in the desktop it works.

Do I need a gateway configured for a website scrape?

dax · ‎08-27-2019

Hi SeanHenderson,

You said when you refresh, nothing change in web service. You could check Setting->dataset to see whether it prompt to configure gateway, it will show like below, you don't need to configure a gateway

In addition, which refresh button did you click , in dataset or in report? You could try to click the "refresh now " in dataset to see whether it works or not. Or you also could wait a mement to see whether this is casued by delay.

Best Regards,
Zoe Zhi

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

Anonymous · ‎08-27-2019

@dax

I clicked refresh now in the dataset, that's where the error occured. It says that I do need a gateway. Is this normal, do you need a data gateway to refresh from a public website?

Also, I configured the gateway by adding the website, but still got an error when trying to refresh:

Can anyone please clarify this for me? Can you not connect a data source to a public website and then have it refresh? And if you do need to configure a gateway, what am I doing wrong?

dax · ‎08-28-2019

Hi SeanHenderson,

According to your error informaion(this seems occur in table 8), did you use refresh schedule or refresh now? If you use refresh now, will it work? I test this in my environment(I use anonymous), it could work.

If you use refresh schedule, you could check whether this occur by accident or occur each time(check this in refresh history). Or did you use specific function which might not be support in service?

You could refer to Troubleshooting refresh scenarios for details.

Best Regards,
Zoe Zhi

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