topic Power BI Report Server Refresh fails in Report Server

Power BI Report Server Refresh fails

Anonymous — Thu, 18 Nov 2021 12:20:33 GMT

Hello everyone,

for scheduled data refresh on Report server I get Error 404:

DataSource.Error: Web.Contents failed to get contents from '****' (404): Not Found. DataSourceKind = Web. DataSourcePath = . Url = . ;Web.Contents failed to get contents from '****' (404): Not Found. The exception was raised by the IDbCommand interface.

Could you please advise on the possible reason for that?

Thanks in advance!

Re: Power BI Report Server Refresh fails

d_gosbell — Fri, 19 Nov 2021 00:16:29 GMT

A 404 is a "not found error" so it look like you are using a call to web.contents and the url you are trying to fetch is no longer valid. You will need to update the url to a valid one.

Re: Power BI Report Server Refresh fails

Anonymous — Fri, 19 Nov 2021 07:14:39 GMT

hello d_gosbell ,

thank you a lot for your answer!

As I can see from the error notifications --> sometimes the refresh is successful, sometimes - not.

There are two data resources --> SQL Server and Web-link (Rest API).

The problem usually occurs with Web-Link.

Any ideas why the refresh is still successful?

Re: Power BI Report Server Refresh fails

d_gosbell — Fri, 19 Nov 2021 09:53:48 GMT

Anonymous wrote:

sometimes the refresh is successful, sometimes - not.

Any ideas why the refresh is still successful?

No I have no idea. It sounds like a problem with the web server.

The fact that report server gets a 404 response means it connects to the web server, but the web server is saying that it does not have the resource that is being requested. You may need to contact someone that supports the web server and see if they can tell you why this happens.

Re: Power BI Report Server Refresh fails

AbhiSSRS — Mon, 22 Nov 2021 18:31:32 GMT

d_gosbell is right! You would need to contact web-link support team for the logs , its possible that its load balanced in some old mechanism and one of them is failing when your request goes to that.

Re: Power BI Report Server Refresh fails

Anonymous — Wed, 24 Nov 2021 09:32:20 GMT

AbhiSSRS , thanks for your answer!

topic Power BI Report Server Refresh fails in Report Server

Power BI Report Server Refresh fails

Hello everyone,

for scheduled data refresh on Report server I get Error 404:

DataSource.Error: Web.Contents failed to get contents from '******' (404): Not Found. DataSourceKind = Web. DataSourcePath = *****. Url = *******. ;Web.Contents failed to get contents from '********' (404): Not Found. The exception was raised by the IDbCommand interface.

Could you please advise on the possible reason for that?

Thanks in advance!

Re: Power BI Report Server Refresh fails

Re: Power BI Report Server Refresh fails

Re: Power BI Report Server Refresh fails

Re: Power BI Report Server Refresh fails

Re: Power BI Report Server Refresh fails

DataSource.Error: Web.Contents failed to get contents from '****' (404): Not Found. DataSourceKind = Web. DataSourcePath = . Url = . ;Web.Contents failed to get contents from '****' (404): Not Found. The exception was raised by the IDbCommand interface.