Connection Timeout Expired - just started doing this on Friday afternoon

[StidifordN]

Morning all, 

Re: a Connection Timeout Expired error when attempting to refresh

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.

[Syndicate_Admin]

Best regards, I had the same problem and solved it with the next step.

Data source configuration > select the source with the disadvantage > change source and in the timeout place 60 minutes.

I hope it serves you...

[v-lid-msft]

Hi @StidifordN ,

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.

Best regards,

[v-lid-msft]

Hi @StidifordN ,

First of all, we suggest you to remove the information of your sql server in your post.

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?

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

Have you tried to use the latest version of Power BI Desktop(from here or update from MS Store)?

Best regards,

[Greg_Deckler]

See if this works: https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/td-p/28645

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And 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]

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