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

skatakam's avatar
skatakam
Regular Visitor
3 years ago

Hi Lydia, 

 

Good afternoon,

 

In our case, this is not working. Tried to connect Azure Managed Instance from PowerBI Service. 

Connection details: Public endpoint , Basic authentication method.

Here is the error:

Failed to update data source credentials: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)Hide details

Please let me know if gateway setup is needed or not ?

 

Thanks

Srihari

 

  • skatakam's avatar
    skatakam
    Regular Visitor
    3 years ago

    Hi Lydia, 

     

    Please ignore my previous message, I confirm i'm able to connect Azure Managed Instance from PowerBI Service. No need of gateway. We must include the port in the connection string. 

     

    Thank You

    Srihari

     

    • jspwilli's avatar
      jspwilli
      Helper I
      3 years ago

      Hi Srihari,

      I'm having the same issue you have just been through.

      I already have the port in the connection string, do you have any other suggestions? Ours looks like xx,#### as a suffix

      • skatakam's avatar
        skatakam
        Regular Visitor
        3 years ago

        Hi, 

         

        Please make sure Public endpoint is enabled under the networking in managed instance. If not enable. Public endpoint connection should work without any issues.

         

        Thanks

        Srihari

         

    • karo's avatar
      karo
      Advocate V
      2 years ago

      Can you please share more details how you did it? I am facing similar issue/error like yours.