topic Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400 in Developer

Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Fri, 02 Sep 2022 13:47:34 GMT

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

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

lbendlin — Sat, 03 Sep 2022 23:14:21 GMT

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.

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Wed, 14 Sep 2022 11:41:48 GMT

Standard Data Gateway installed and is up and running on my Power BI Service

But still I am unable to update my database crendentials and getting below error

Please note that

SQL Server is on Port 8004
Data Gateway is configured using official domain Id which requires MFA for logins

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

lbendlin — Tue, 13 Sep 2022 21:34:25 GMT

Data Gateway is configured using official domain Id

what made you choose that? Using the default service login is the safest and most robust option.

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Wed, 14 Sep 2022 11:42:29 GMT

I cant find any option to configure Standard Data Gateway other than email id

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

lbendlin — Wed, 14 Sep 2022 13:57:32 GMT

Ah, sorry - that is fine (and will work with MFA). This step is not actually required for the gateway to function.

I was thinking of the gateway service (which is crucial to be running) that usually should run under the default service login.

You are getting an error 400 which might be pointing to a resource mismatch on your data source. Can you create another connection against a different SQL data source and see if you can reproduce the issue?

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Thu, 15 Sep 2022 20:01:53 GMT

I tried connecting the different data base creating an entirely different report then published it but all in vain then I tried publishing it on a different workspace it didn't work

I think the error I am recieving could be related to SQL Server Browser - Please see below that SQL Server Browser is running with "Local Service", is it the right configuration for Data Gateway Connection ?

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Fri, 16 Sep 2022 11:15:07 GMT

Also, I noticed that on SQL Server Folder We don't have any permission for user "PgiEgwService" - Can this be an issue

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

lbendlin — Fri, 16 Sep 2022 11:37:51 GMT

These two settings should not have an impact.

Do you have the option of uninstalling and reinstalling the gateway software? You would choose the "Recover a gateway" option when you launch the admin tool. This is also a great opportunity to test your recovery key.

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Fri, 16 Sep 2022 14:23:01 GMT

Tried uninstalling and installing the gateway several times - tried recovering the existing gateway and it was successful but still the same error occurs everytime on Power BI Service

In logs of data gateway there is a file FailedFileNames.txt

C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\GatewayErrors20220916.000000000.log, C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\GatewayInfo20220916.000000000.log, C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\GatewayNetwork20220916.000000000.log, C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\SapAdapter20220916.000000000.log, C:\Users\chms03\AppData\Local\Microsoft\On-premises data gateway\GatewayConfigurator20220916.000000000.log

Opening the first file GatewayErrors20220916.000000000.log

I can see this error

" A network-related or instance-specific error occurred.."

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

lbendlin — Fri, 16 Sep 2022 15:04:40 GMT

would you mind showing a sanitized version of your connection string? It needs to end with ,8004 not with :8004

Re: Data Gateway Personal Mode | Failed to Update Data Source Credentials | Status Code 400

Anonymous — Tue, 20 Sep 2022 07:48:53 GMT

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