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

maxxmilo's avatar
maxxmilo
Helper I
5 years ago

Hi, we just upgraded from SQL DB to managed instance, and our DirectQuery stopped working in the cloud service (connection to the managed instance works fine on PowerBI desktop). Has this been addressed/solved yet?