Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
Hi @MojoGene,
Great to hear the problem got resolved. Could you accept your reply above as solution to close this thread?
Regards
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.