Use proxy for web Data source in PBI Report Server

[rupayan87]

Hi,

I need to connect to a data source which is basically an API URL. The server that has PBIRS installed, the API can be accessed only using a proxy. So after I go to internet options and change the LAN settings to use the proxy, I can reach the API by accesing it in browser.

However in report server when I onfigure the data source with the API URL, add an account for Basic authentication  and try to test the connection I get the below error

"unable to connect the remote server"

Is there a way to specify in the data source to use a sepcific proxy while trying to connect to the API.

[rupayan87]

ok, I changed the proxy settings for the Service account with which PBIRS is configured. Now I get the below error when i try to test connection with data source.

2020-09-01 08:26:01.9101|ERROR|55|OData exception occurred: System.Net.WebException: The remote server returned an error: (403) Forbidden.
at System.Net.HttpWebRequest.GetResponse()

I tried to use Basic Authentication and gave the account/pwd for accessing the API.

Once again, when I try to access normally from browser, I can access the API URL. Any ideas?

[rupayan87 · Accepted solution]

Alright this is fixed. I logged in to the server using the PBIRS service account, set the proxy and then restarted the PBIRS service. 

[ClaraPS33]

Hi. How do you configure proxy? From the server thats use Power BI Report Server or from Power BI Report Server environment?

Thanks