Forum Discussion
Understanding Gateways for SQL
I'm confused on how to set up a gateway and the microsoft documentation is confusing. The SQLdatabase is not hosted on my computer. Do I need to make a gateway on my computer for service to pull the data or does the computer that the server is hosted on need to set up a gateway. If it is the host computer how do I then add the gateway to my powerBI service account?
You need to install the data gateway on a Windows machine (or virtual machine) ideally on the same network but not the same server as the SQL database. Avoid installing on a PC that may or may not be running whenever the gateway needs to be accessible (refreshes, dataflow development).
Once that's done you have a quick setup to do on the Power BI service so that it's aware of the gateway and has the necessary source credentials.
8 Replies
You need to install the data gateway on a Windows machine (or virtual machine) ideally on the same network but not the same server as the SQL database. Avoid installing on a PC that may or may not be running whenever the gateway needs to be accessible (refreshes, dataflow development).
Once that's done you have a quick setup to do on the Power BI service so that it's aware of the gateway and has the necessary source credentials.