Forum Discussion
Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400
Hi All,
I am using Data Gateway (Personal Mode) in one of our On-Prem Windows Server runnning SQL SERVER 2014
The Data Gateway can be seen Up and Running in Power BI Service
Whenever I setup the credentials I get below error
When I pass the incorrect credentials it returns the same error, so actually error is returned even before authentication takes place
On a Windows Server you should set up the Enterprise/Standard gateway, not the Personal Gateway.
Check your Proxy settings and make sure the gateway can successfully communicate with the Azure backend.
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
11 Replies
On a Windows Server you should set up the Enterprise/Standard gateway, not the Personal Gateway.
Check your Proxy settings and make sure the gateway can successfully communicate with the Azure backend.
Data Gateway is configured using official domain Idwhat made you choose that? Using the default service login is the safest and most robust option.
would you mind showing a sanitized version of your connection string? It needs to end with ,8004 not with :8004