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 ...
Romans's avatar
Romans
New Member
10 years ago

Getting the same error while same tables update in excel flawlessly. What can I do? :(

  • Sreekanth's avatar
    Sreekanth
    Advocate I
    9 years ago

    Getting the same error, what can we do to avoid? 

  • Sreekanth's avatar
    Sreekanth
    Advocate I
    9 years ago

     

    Getting the same error, please let us know if we can modify the connection time-out value in PowerBI desktop application?

  • Sreekanth's avatar
    Sreekanth
    Advocate I
    9 years ago

     Getting the same error, please let us know if we can modify the connection time-out value in PowerBI desktop application?

     

     

    • Sreekanth's avatar
      Sreekanth
      Advocate I
      9 years ago
      I am able to resolve the issue by adding the value in advanced options of edit queries as mentioned in below. Edit Query->Click on Source->Properties and in advanced options mention the value (number of minutes) it can wait to run the query. Please vote if it helps you .
      • Jaikrit94's avatar
        Jaikrit94
        Helper I
        9 years ago

        I followed the advice of Sreekanth (the post above) and entered a value of 60 minutes into the advanced options menu and it ended up refreshing the Power BI Desktop file for me. 

         

        I believe the reason I (and a number of others) were facing this issue is because the dataset/file being used is quite big. For example, I was using several views from Microsoft SQL that contained data from January 2015 till November 2016. 

         

        Here is a step by step guide of what I did - I followed Sreekanth's instructions...

         

        1. Have the Power BI Desktop file open and in Report View
        2. Click on the arrow for "Edit Queries" (in the External Data section) 
        3. A dropdown will appear - then click "Data Source Settings"
        4. Data source settings pop-up window will appear
        5. Click on "Change Source..."
        6. Another pop-up will appear 
        7. Click on Advanced Options (a drop-down of sorts will appear within the pop-up)
        8. "Command timeout in minutes (optional)" will be the first option
        9. Enter a value - I chose to enter 60 minutes but feel free to enter any value
        10. Then apply the query changes and wait till the refresh is complete

         

        I hope this helps!