User login failure in APP and Gateway

[Fehling]

Also unable to add to gateway

Hello all,

one of my sources is a PostgreSQL database which uses a login different from the windows user/password.

It works fine within PowerBI Desktop but runs an error in the app.powerbi.com. It states the following error message. Adding the source to the gateway does not solve the problem but generates a similar error (see above).

Can someone help me solving the issue or point me in the right direction.

Regards,

F.

Error connecting PostgreSQL user login

[v-yangliu-msft · Accepted solution]

Hi  @Fehling ,

The 400 ERROR means a bad http request. Please updata on-premise gateway to the lastest version. If you already have updated the gateway to the latest version, then you can refer to steps below for troubleshooting.

1. Check if the server is using a proxy and the proxy. Some proxies restrict traffic to only ports 80 and 443. By default, communication to Azure Service Bus will occur on ports other than 443.

2. You can force the gateway to communicate with Azure Service Bus using HTTPS instead of direct TCP. You will need to modify the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file. Change the value from AutoDetect to Https. This file is located, by default, at C:\Program Files\On-premises data gateway.

3. Restart the gateway and check if the issue persists. 

To stop the service, run this command:

''' net stop PBIEgwService '''

To start the service, run this command:

''' net start PBIEgwService '''

4. You may export the data gateway log by selecting Diagnostics and then selecting the Export logs link near the bottom of the page. Reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting.

This is the related document, you can view this content:

https://community.powerbi.com/t5/Service/HELP-quot-We-could-not-register-this-data-source-for-any-ga...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tutu_in_YYC]

In the Fehlermeldung, it requires you to install the latest Npgsql. Have you tried that?