topic Re: What configuration is needed to enable scheduled refesh of a web data source ? in Report Server

What configuration is needed to enable scheduled refesh of a web data source ?

bp — Wed, 15 Nov 2017 18:13:10 GMT

Does something need to be configured on the Report Server in order for a Report Server data source to access a website (with no api key)

The Test Connection doesn't work and hence the Schedule Refresh isn't possible.

Thanks

Re: What configuration is needed to enable scheduled refesh of a web data source ?

v-yulgu-msft — Fri, 17 Nov 2017 02:56:48 GMT

Hi bp,

You said "Test Connection" doesn't work, do you mean it failed to connect to Web source? Does the website need a credential to authenticate? If so, please make sure the account and password you entered are correct and still valid. What the error message did you see when "Test Connection"?

Could you refresh data source successfully in desktop? Also, to enable schedule refresh, please make sure your SQL Server Agent is running.

Reference: Power BI report scheduled refresh in Power BI Report Server

Regards,

Yuliana Gu

Re: What configuration is needed to enable scheduled refesh of a web data source ?

bp — Fri, 17 Nov 2017 11:50:27 GMT

Hi Yuliana,

the web source has no api key and the only credential it should need to connect is to be a valid Active Directory user on our network.

The account and password I have tried are valid and the web source can be reached via a browser on the server where Power BI Report Server is hosted

The error message is as follows (tried with all 3 authentication types)

Couldn't connect

The data can be refreshed successfully in the desktop application

We have SQL Server Agent running on the Power BI Server and it has been configured to successfully refresh SQL Server database table data sources.

Thanks for your time