Forum Discussion

mwiggins's avatar
mwiggins
New Member
10 years ago

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 make connection to the DB from SSMS also.

 

Below is error message received:

 

Failed to import data

Do you want to delete the dataset and report?

Activity Id 302ed95c-f8ef-4dc7-9dc7-f9229dd96e6d

Status Code 200

Time Thu Oct 01 2015 16:25:11 GMT

Version 11.0.9168.162

Cluster URI https://wabi-west-us-redirect.analysis.windows.net

 

Any guidance is appreciated.

 

thanks,

Mark

 

7 Replies

  • mwiggins's avatar
    mwiggins
    New Member
    10 years ago

    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

    • mwiggins's avatar
      mwiggins
      New Member
      10 years ago

      Wow, I'm overwhemled by the responses. This is a great support forum.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        mwiggins by "verified the firewall rule is set to on" can I assume that the IP you set as a rule is not your internal network IP, but is the IP that your internet connection has, and that the user you are trying to connect to the database has permissions.

        My initial impression is that this is a config issue and not a Power BI issue.