Forum Discussion
SQL Server on Azure VM not connecting via on-premises gateway
Hi harryws ,
The IP address of the VM should be used when connecting to SQL Server on an Azure VM, the ___.database.windows.net format is usually used for Azure SQL Database, it's a different service, here SQL Server is on an Azure VM, so I think you should go ahead and use the IP address of the VM.
The second is that you mentioned that you use the Database credentials in Power BI Desktop, so you should choose Basic as the authentication method in the Power BI service.Finally, I think you can check out this official document for a more in-depth study: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi harryws ,
The IP address of the VM should be used when connecting to SQL Server on an Azure VM, the ___.database.windows.net format is usually used for Azure SQL Database, it's a different service, here SQL Server is on an Azure VM, so I think you should go ahead and use the IP address of the VM.
The second is that you mentioned that you use the Database credentials in Power BI Desktop, so you should choose Basic as the authentication method in the Power BI service.
Finally, I think you can check out this official document for a more in-depth study: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.