Forum Discussion
Adding a header to a web API request in the data sources section of a report in PBI Report Server
This part of your error message
The remote name could not be resolved
sounds like there is a firewall or proxy or something in your network configuration blocking your server from accessing the remote api source. Or the service account that is running your report server instance does not have permission to access external sites. I suggest you talk to your IT team about this.
I am experincing the same issue as OP. When I try to refresh through Report Server, I get a "Login failed for data source" error. I have set the authentication type as anonymous. Refreshing through PowerBI desktop works fine.
Error details:
Data source error: Login failed for data source ‘API URL HERE’.
SessionID: ID HERE [0] -1055784932: DataSource.Error: The remote name could not be resolved: 'api.smartrecruiters.com'. (API URL HERE). The exception was raised by the IDbCommand interface.
Any ideas? Also would like to hear from OP if they have experienced a similar error as me.
This part of your error message
The remote name could not be resolved
sounds like there is a firewall or proxy or something in your network configuration blocking your server from accessing the remote api source. Or the service account that is running your report server instance does not have permission to access external sites. I suggest you talk to your IT team about this.
I think you're right. Talking to IT, it sounds like outside communication is not allowed for our report server. Thanks!