Unable to update this data source's credentials. The analysis request operation is timed out before it was completed

Question

Hi,

I am trying to setup Data Gateway on my On Premises Windows Server with SQL Server 2014 installed running on Port 9003

The Latest Data Gate way installed (downloaded 14th Sep) in standard mode is running fine as we can see it appearing on Power BI Service

In Power BI Desktop the query timeout is set to 200 and the data is only a few KBs

Now, whenever we try to add credentials using "Basic" method for data source and provide the respective database's credentials, it gives us below error (image attached) - Not sure exactly why it happening but below 2 things to be noted

• If we give incorrect password it returns the same error - means the error is returned even before the authentication
• If we give incorrect server IP then it returns a different error "a network related or instance specific error occurred..." - means the PBi Service is able to access the server when given the correct IP,port

Answer 1

This has been resolved - It was actually a Network Issue pertains to NAT Loopback.

The network I have been working on does not support NAT Loopback - Data Gateway and SQL Server was installed on same network servers and I have been trying to connect the Data Gateway with SQL Server using Public IP rather than local IP - As I mentioned NAT Loopback was not enabled therefore Data Gateway was not able to access the SQL Server with Public IP. When it was setup using local IP, it worked

Moreover, It is working with Personal Gateway too