Forum Discussion

StidifordN's avatar
StidifordN
Icon for Helper III rankHelper III
6 years ago

Connection Timeout Expired - just started doing this on Friday afternoon

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 iss...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

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,