Forum Discussion

rerangel's avatar
rerangel
Icon for Helper I rankHelper I
8 years ago

on premise gateway Invalid credentials

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 admi...
deldersveld's avatar
deldersveld
Icon for Resident Rockstar rankResident Rockstar
8 years ago

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's avatar
rerangel
Icon for Helper I rankHelper I
8 years ago

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's avatar
    GilbertQ
    Icon for Super User rankSuper User
    8 years ago
    It should be working fine. Can you connect from your Gateway server to the SQL server?
    • rerangel's avatar
      rerangel
      Icon for Helper I rankHelper I
      8 years ago

      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's avatar
        GilbertQ
        Icon for Super User rankSuper User
        8 years ago
        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.