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): "We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server."
P.S. Powerpivotus refreshus didn't work :(