Forum Discussion

CLWendt88's avatar
CLWendt88
New Member
5 years ago
Solved

Connect to SQL Server instance on Azure VM without Data Gateway

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 Priva...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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