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
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

ajil's avatar
ajil
Frequent Visitor
8 years ago

Azure SQL server Managed Instance is a cloud data source, but inside virtual network. Data Loading and Reading will not be a public access. I am wondering how Power BI will handle this without a Gateway? 

 

-Ajil