Forum Discussion

davidutl's avatar
davidutl
Frequent Visitor
8 years ago
Solved

Azure SQL Server Managed Instance

With the new Azure SQL Managed Instance coming soon is there any indication how Power BI might handle this? Will it be treated as a SQL Database connection possible through the gateway, an Azure SQL...
  • Anonymous's avatar
    Anonymous
    8 years ago

    davidutl,


    Azure SQL server Managed Instance is a cloud data source, which is similar as Azure SQL database, when you refresh the dataset that contains the data source, gateway is not required. You "Connect Directly" to the data source in Power BI Service.

    And in Power BI Desktop, it is possible to use Azure SQL database connector to connect to the Azure SQL managed instance.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

davidutl ajil,

I get response from PG:

"At the moment, gateway is needed for PowerBI Online to access Azure SQL Managed Instance residing in customer’s virtual network, just like with SQL Server on-premises.

I would also add that later this year Managed Instance is going to offer optional public endpoint, which will allow PowerBI Online to access it directly, without need for gateway, which will also unlock OAuth2 (AAD) authentication option."



Regards,
Lydia

vidyadudipala's avatar
vidyadudipala
Frequent Visitor
7 years ago

I have exact similar situation and am not eager to have a VM sitting all day long and running gateway.

Do we have any road map or timeline around the optional public end-point or any other better way of getting this ?