Forum Discussion
Gateway - 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...
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.