Forum Discussion
SQL Sever Connection
Hi jland47 -Install the Power BI Gateway on a single, reliable machine within your local network that is always available. It does not need to be on all machines, only on one central or dedicated PC that has network access to your on-premises data sources and a stable connection to Power BI’s cloud services.
Hope this helps
Hi jland47 - Since your on-premises SQL server requires a connection outside of Power BI’s cloud service, you need to use the On-premises Data Gateway. Ensure that the gateway is correctly installed and configured on a machine in your network that can access the on-premises SQL server.
You can download and set up the gateway by going to Power BI Service > Manage Gateways. Make sure the gateway can communicate with your on-premises server and that your user account has permissions for the gateway.
Step2:
After setting up the gateway, go to Power BI Service > Settings > Datasets > select your dataset.
Under Gateway Connection, map the data source to the on-premises gateway and ensure that the credentials for the connection are correctly set. You should set up both the cloud SQL server and on-premises SQL server within the same dataset's gateway settings.
Step3:
Make sure you are using the correct authentication method. In many cases, Windows authentication might cause issues if the Power BI Service can't impersonate your local account (like as\administrator).
For the on-premises SQL server connection, consider using Basic authentication with SQL Server credentials or configure the gateway to impersonate a specific SQL login that has permissions on the SQL Server instance.
Step4:
Verify that the on-premises SQL server allows remote connections. In SQL Server Management Studio, go to the SQL Server Configuration Manager and check if remote connections are enabled.
Hope the above steps works to configure the same.
Not sure if I followed your steps exactly but, I got it to work by downloading a new gateway version which let me creat a new gateway connection. Once I had that done I added it the the gateway cluster already installed and it worked.
Yes, it is a good solutions by downloading the gateway version
Downloading the gateway version on what pc, should the gateway be on all machines or should it only be on my network local pc?
Ok, will try to follow exactly. Just to make sure I inderstand fully though, because I went in and deleted gateways and reinstalled them, I think I will go delete all of them again and start over. My scenario, I have my local network pc (has power bi desktop), one server with sql (app-01, its a cloud based server, didnt have a problem with this before trying to add the other server on), and on premise server with sql (rdsvr). Where should I install the gateway? On my local pc and add both connections under the same gateway cluster? Or should each server have a gateway installed on them?
