Connect to SQL Server instance on Azure VM without Data Gateway

[CLWendt88]

Is it possible to connect to to a SQL Server instance running on an Azure VM without the data gateway?  

Maybe by whitelisting the IPs of the Power BI service? 

Or is there a way to use Private Endpoints so Power BI Service can securely access the SQL instance?

[Anonymous · Accepted solution]

Hi @CLWendt88 ,

You are connecting to a SQL Server that hosted in Azure VM but not Azure SQL database in Power BI Desktop. For the former, gateway is required, you can install gateway on the same machine with Power BI Desktop, then add SQL Server data source within the gateway. Otherwise, you are not able to view the published report in Power BI Service.
For Azure SQL database, gateway is not required.

Best Regards,

Jay