topic Re: Datasource with Web connection error in Report Server in Report Server

Datasource with Web connection error in Report Server

SANDRALIA — Wed, 26 Jun 2024 23:32:43 GMT

Hi Friends!
I load a table from "https: // bna.com.ar" , I can see ok in the report but when is uploaded to PBI Report Server (optimized for reporting), show error. (see msg at bottom)

I tried in anonymous way, and also fixing windows credentials in the report but always is rejecting in Report Server datasource administration.
Can somebody help me please?

Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
The remote name could not be resolved: www. bna.com.ar

Re: Datasource with Web connection error in Report Server

aduguid — Wed, 26 Jun 2024 23:56:55 GMT

I would setup a domain user that has access to the site and use that in the connection string.

Re: Datasource with Web connection error in Report Server

SANDRALIA — Thu, 27 Jun 2024 00:24:59 GMT

thank you aduguid , it's a public web page... In cannot setup an user with this domain..
What Im doing wrong?

Re: Datasource with Web connection error in Report Server

aduguid — Thu, 27 Jun 2024 00:36:14 GMT

The user in the connection string would need permissions to access the site. You can try with your user name and password as a test. If it works then I would have your infrastructure team setup a domain user "service account" on your network that then can access the site. You can test with the service account by holding the shift key down right click on Microsoft Edge. Then you can "Run as different user" and enter the service account.