AnalysisServices: The remote server returned an error: (407) Proxy Authentication Required

[chayanupadhyay]

I am getting below error while connecting to Azure Analysis service:

Details: "AnalysisServices: The remote server returned an error: (407) Proxy Authentication Required."

Anyone can help me to troubleshoot this issue.

[v-jiascu-msft]

@chayanupadhyay

Hi,

Please reference this post:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b81f0d7b-fdd8-41ba-a0e8-974944d3a60c/error-...

Best Regards!

Dale

[chayanupadhyay]

Thanks @v-jiascu-msft for your reply.

As per the solution provided in shared link:
Add below code into your config file. You have to configure the proxy authenctication if your pc performs HTTP requests through a proxy. Stick the following config section in your app.config\web.config and you should be ok to move on:

<system.net>
<defaultProxy useDefaultCredentials="true"></defaultProxy>
</system.net>

I am using my company's network so can you please guide me which config file should i edit and add the above code snippet?
There may be a possibility where i don't have access to the file which needs to be edited so is there any other workaround/resolution for this issue?
Thanks !!!

[v-jiascu-msft]

@chayanupadhyay

Hi,

My pleasure. I am not quite familiar with Azure. According to the guide, it seems the files of Power BI. It depends on the path of Power BI. There are there .config file. I would modify "PBIDesktop.exe.config". Backup files before you act. 

Best Regards!

Dale

[chayanupadhyay · Accepted solution]

I did try that but unfortunately it does not work.. but we got the solution for the issue

We have to use Proxy server instead of Automatic Configuration script...Used public IP to connect with Azure Analysis service.

Below are the steps followed, hope somebody else can benifit from this:

Go to Internet Options -> Connections -> LAN Settings 

below settings were implemented when we were not able to connect:

Then instead of Automatic Configuration Script selected Proxy server -> Go to Advanced and enter the Public IP and Port  and check the checkbox as displayed in below snapshot:

 Click Ok and we are able to connect to Azure Analysis Service.

Thanks and Happy Learning !!!!