on premise gateway Invalid credentials

[rerangel]

Hi 

I have a Sql Server running ok. I have Windows Domain admin credentials. 

I installed the gateway in a VM with windows server 64 bits succesfully.

I have Power bi Pro licence and i am the administrator of the service.

I publish my reports ok. They work very nice.

The gateway appears ON LINE in the service,

i add data origins using windows credentials, even using my credentials (above mentioned) and get OK. Its say that the gateway is on line.

But when i update or refresh the reports from the service i get this error:

Ha habido un error (there is an error)

Credenciales de conexión no válidas. (Invalid credentials)
Vuelva a intentarlo más tarde o póngase en contacto con el soporte técnico. Proporcione estos detalles si se pone en contacto con ellos. (try later or contac thecnical support, give this details if you contac them)

URI de clústerWABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net

Identificador de actividad8c180956-2ba3-bfcb-814b-81bec1d30f28

Identificador de la solicitud70e61078-4ad1-80e7-b6f3-6a21de5e2e93

Hora2018-05-21 17:30:16Z

I have tried everything that are in the troubleshoting docs from Microsoft.

What can it be?

Rafael Rangel
Bogota- Colombia

[deldersveld]

A client recently had this issue, and it ended up being an SSL certificate issue. The cert did not match the connection string used in the Power BI connection. Another workaround they found while not ideal would be to use a SQL login instead of Windows.

[rerangel]

Hi.

I recently read about the SSL Certificate, tha is installed by de Personal Gateway.

I unistall on premis gtw. and installed Personal Gateway. 

Didnt work.

[GilbertQ]

It should be working fine. Can you connect from your Gateway server to the SQL server?

[rerangel]

Hi GilbertQ

Yes.  the computer where the gateway is installed, has Windows 2012 server 64 bits. I have Sql SSMS and connect to de database without problem.  I make querys and work fine. 

In the domain controler is installed the Sql Server.  My windows user has Domain admin credentials. 

In the Power Bi Service the gateway appears ON LINE. no errors.  I created the data Origins, to sql server, with windows credentials, get on line. Until here, everything just fine. piece of cake.

Buut when i go to the data set and try to refresh or the automatic schedule try to refres, get the invalid credential error.

I read the troubleshooting docs. 

We dont have proxy. 

Another says the SSL and must install personal gateway, wich i did, but same result.

So, i have not solve this mistery yet.

[GilbertQ]

Hi there,

If you have a power bi pro licence. I would log a support request and they can find out exactly what is going wrong. As I'm not sure what else could be causing it to fail.

[rerangel]

Hi 

I found the problem with de invalid credentials error. The plataform where de VM (windows DC and the VM for the on premise gateway) ,  run is Linux. And the IT guy has a linux based proxy  call Zentian. 

We disconnect Zentian, and the on premise  gateway run smoothly. 

We prove that this linux based software has his issues with the gateway. 

So, the IT guy conect a Patch cord from a NIC from the SQL server VM and the Powerbi gateway VM. And from the last  one,  another patch cord  to the router the get the wan. 

So, the gateway VM doesnt past trought the Zentian proxy. 

Problem solved. 

[GilbertQ]

That is great news, glad you found the issue and you got the Gateway working!

[rerangel]

Hi

Thanks for your time.

I changed the credentials in the gateway  from windows to Basic. 

The sql user has full persmisions sysadmin.

saddly It didnt work.  

I am gona dig up about SSL certificate.

Thanks  for your help. 

[GilbertQ]

Hi there, does your SQL Server use Encryption?

[rerangel]

Hi

The sql doesnt use Encryption