Forum Discussion

SiroPW's avatar
SiroPW
Helper I
8 years ago
Solved

SQL Server hosted on Azure VM - Do I need a Gateway?

Among other data sources - I have an SQL Server database hosted on an Azure VM.   I can connect with DirectQuery through PowerBI Desktop and make reports I'd like. However when publishing to PowerB...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    SiroPW,


    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.

    Regards,
    Lydia

SiroPW's avatar
SiroPW
Helper I
8 years ago

Publishing a report with purely one table from a SQL Server DB hosted on Azure I get:

 

 

Also, trying to go directly to the service (it still publishes) and updating the data settings field is greyed out as it expects to connect via a Gateway.

 

 

Would love to know how to get around this!

Thanks.

imenmaiza's avatar
imenmaiza
Helper II
2 years ago

Hello SiroPW,

Could you please explain to me how you did connect to SQL Server database hosted on an Azure VM through PowerBI Desktop in the first step? which connector?