Forum Discussion

stangellapally's avatar
stangellapally
Frequent Visitor
10 years ago

sql connection time out from power bi desktop

Hello,   I am trying to connect to one my SQL Server from Power BI Desktop to get data.... these days our servers are little slow as we are in some transition process. The work around we are using ...
pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Unfortunately there isn't a way to customize the connection timeout (yet). The hardcoded value should be more than 100 seconds. This is a good suggestion though! You should definitely vote for it at the feature request page. I'll also personally track it since I heard about this often enough.

  • stangellapally's avatar
    stangellapally
    Frequent Visitor
    10 years ago

    Thanks for the Reply Pqian!

     

    How am I suppose to vote this for Feature request page?

    pqian wrote:

    Unfortunately there isn't a way to customize the connection timeout (yet). The hardcoded value should be more than 100 seconds. This is a good suggestion though! You should definitely vote for it at the feature request page. I'll also personally track it since I heard about this often enough.

     

    • anoopcse's avatar
      anoopcse
      Icon for Helper I rankHelper I
      10 years ago

      Hi there,

       

      I am finding a connection timeout issue with Power BI Desktop while connecting to SQL Server 2016 CTP 2.0. I am trying to get data from AdventureWorks DimProduct and other tables, but it is failing with the below error:

       

       

      "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC erro: [DataSource.Error] Microsoft SQL:Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be becuause the pre-login handshake filed to the server was unable to respond back in time. The duration spent while attempting to connect to this serve was - [Pre-Login] Initialization=21008;handshake=1"

       

      Any isights to this is much appreciated ?

       

      Cheers,

      Anoop

    • anoopcse's avatar
      anoopcse
      Icon for Helper I rankHelper I
      10 years ago

      Hi there,

       

      I am finding a connection timeout issue with Power BI Desktop while connecting to SQL Server 2016 CTP 2.0. I am trying to get data from AdventureWorks DimProduct and other tables, but it is failing with the below error:

       

       

      "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC erro: [DataSource.Error] Microsoft SQL:Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be becuause the pre-login handshake filed to the server was unable to respond back in time. The duration spent while attempting to connect to this serve was - [Pre-Login] Initialization=21008;handshake=1"

       

      Any isights to this is much appreciated ?

       

      Cheers,

      Anoop

      • anoopcse's avatar
        anoopcse
        Icon for Helper I rankHelper I
        10 years ago

         

        This is the error I am getting

         

        Cheers,

        Anoop