Data from SQL won't refresh

[ronweasley]

Hello everyone!

My PowerPivot won't refresh data from SQL, even though I'm able to access the server just fine. Another machine, which has the same rights, refreshes well. The button "Test connection" says the connection is fine.

An odd detail: my machine won't let me set connection timeout to more than 64,434 -- says connection test failed. The other machine can set the connection at 1,000,000.

Here's the error message I'm getting (after about an hour of waiting every time):

P.S. Powerpivotus refreshus didn't work 😞