topic Use proxy for web Data source in PBI Report Server in Report Server

Use proxy for web Data source in PBI Report Server

rupayan87 — Tue, 25 Aug 2020 12:50:11 GMT

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.

Re: Use proxy for web Data source in PBI Report Server

rupayan87 — Tue, 01 Sep 2020 12:40:15 GMT

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?

Re: Use proxy for web Data source in PBI Report Server

rupayan87 — Tue, 01 Sep 2020 18:38:25 GMT

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

Re: Use proxy for web Data source in PBI Report Server

ClaraPS33 — Fri, 27 May 2022 11:23:33 GMT

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

Thanks