cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Use proxy for web Data source in PBI Report Server

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

2 REPLIES 2
Highlighted
New Member

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?

Highlighted

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors