Forum Discussion
PremK
Resolver I
Resolver IGateway - MS SQL Server ( On-Premises )
Im using MS SQL Server as Data Base, which is on-premises server. I had build a report in Power BI using this Data base. To refresh this data set in PBI Service, Is it possible to connect this d...
PremKResolver I
Resolver ICan 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.
AnkitKukreja
Super User
Super UserHi! 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-app