Connection Timeout Expired - just started doing this on Friday afternoon

Question

Morning all,&nbsp;&nbsp;Re: a Connection Timeout Expired error when attempting to refresh&nbsp;Any ideas what to do with the below?Discussed with others in the company and they are not having the same issue so it is likely isolated to my PBIdesktop.&nbsp;&nbsp;

greg_deckler · Answer

See if this works:&nbsp;https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/td-p/28645
&nbsp;
You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd if it is not there, then you could post it.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

stidifordn · Answer

Cheers, i'll have a read.And i forgot to put in the original post - i get the timeout error within 10 seconds of attempting a refresh, not minutes/hours

v-lid-msft · Answer

Hi&nbsp;StidifordN&nbsp;,
&nbsp;
First of all, we suggest you to remove the information of your sql server in your post.
&nbsp;
Could you please verify if you can successfully connect the same sql server by using SSMS or other Official tools? Have you tried to increase the value of connection timeout and command timeout in you query such as following?
&nbsp;
let
    Source = Sql.Databases("Sql_IP_Address", [CommandTimeout=#duration(0, 0, 20, 0),ConnectionTimeout=#duration(0, 0, 20, 0)]),
    DatabaseName = Source{[Name="DatabaseName"]}[Data],
    TableName = DatabaseName{[Schema="SchemaName",Item="TableName"]}[Data]
in
    TableName
&nbsp;
Have you tried to use the latest version of Power BI Desktop(from here or update from MS Store)?
Best regards,
&nbsp;

v-lid-msft · Answer

Hi&nbsp;StidifordN&nbsp;,
Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.
&nbsp;
Best regards,