Solved: Connect to SQL Server instance on Azure VM without...

CLWendt88 · ‎12-02-2020

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 · ‎12-07-2020

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

View solution in original post

Anonymous · ‎12-07-2020

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