Configure Gateway Installation?

[MojoGene]

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 the gateway installation is not recognized. I am directed to a link for installation of the personal gateway, but that link does not work.

The data source is an on-premises SQL database.

How do I configure the enterprise gateway to refresh the PBI report?

Any help would be appreciated.

[GilbertQ]

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]

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]

Hi @MojoGene,

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

Regards

[MojoGene]

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.