Forum Discussion
Failed to Import Data - SQL Azure direct connection
First time attempting to make a direct connection to a SQL Azure DB from Power BI portal. I have verified the firewall rule for Azure services is set to ON in my database service. I've verified I can...
I am now trying from Power BI Desktop to connect to the same SQL Azure database and get the following:
Unble to Connect
Details: "Microsoft SQL: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=58; handshake=14931; "
I am able to connect fine with SSMS to the SQL Azure database from the same machine. Any ideas?
thanks,
Mark