Forum Discussion
Gateway - MS SQL Server ( On-Premises )
No, pls don't do it this way!
Use one stand-alone VM, only for your GW client.
This VM (with your GW) should then has FW-rule to be able to connect to your SQL Server.
Pls don't use GW on the same VM where SQL Server is stored.
Regards
Can you pls give some more details about this.
what is FW-rule and what do you mention as standalone Virtual Machine, and even if i setup this separate VM, how it could connect with SQL Server and PBI.
Can you explain these pls.
Hi! PremK
Once you have a separate VM you have to open the ports and make sure IP of both VMs can interact with one another, for detailed setup you might have to go through the documentation.
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-appare you the very first one in your company leveraging power bi report based on on-premises source? I'd ask internally if there's already a gateway installed and configured you can use.
in that case you only need to add the data source to that gateway... or maybe it already exists and it must shared with you.
