Forum Discussion

MojoGene's avatar
MojoGene
Post Patron
9 years ago

Configure Gateway Installation?

I just installed the on-premises data enterprise gateway and the installation is apparently successful (below). I then published my PBI Desktop report, but when I go to configure the refresh schedule...
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi MojoGene 

 

When working with SQL Server databases and the On-Premise gateway ensure that the name you use to connect to your databases is identical when setting up the connection in your gateway settings in the Power BI Service.

 

For example when connecting in Power BI Desktop you put in the following names:

 

Server Name: DatabaseServer1

Database Name: Sales

 

Now when in the Power BI Service if you had to put the following it would not work

 

Server Name: DatabaseServer1.mydomain.com

Database Name: Sales

 

This is because the Power BI Service looks at the Power BI Desktop file and where they match exactly, it will determine that these are the same, and then enable the data refresh, as well as the direct query.

  • MojoGene's avatar
    MojoGene
    Post Patron
    9 years ago

    guavac:

     

    Thanks for the reply. Not sure where I was going wrong, but I uninstalled the gateway, restarted and then installed the personal gateway. Everything is connected now and the personal gateway will serve my needs.

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi MojoGene,

       

      Great to hear the problem got resolved. :smileyhappy: Could you accept your reply above as solution to close this thread?

       

      Regards

      • MojoGene's avatar
        MojoGene
        Post Patron
        9 years ago

        JerryLi:

         

        I never got to the point in the gateway setup process where I could enter my database name and credentials, so I believe the problem lies elsewhere.