Forum Discussion

atefaly01's avatar
atefaly01
Regular Visitor
9 years ago

get data from Azure SMSS

Hi, 

I have finished T-SQL course , used Azure SSMS 

I'd like to enroll for Power BI course and would like to import the working data from SQl 

I use my Microsoft user for Azure login with my personal email address . 

When trying to sign in to BI , it asks for company / student email .. so I can't connect to my resources of SQL on Azure portal 

I need your support to make it accessible 

Thanks 

Atef Abdelwahed 

6 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    atefaly01 wrote:

    Hi, 

    I have finished T-SQL course , used Azure SSMS 

    I'd like to enroll for Power BI course and would like to import the working data from SQl 

    I use my Microsoft user for Azure login with my personal email address . 

    When trying to sign in to BI , it asks for company / student email .. so I can't connect to my resources of SQL on Azure portal 

    I need your support to make it accessible 

    Thanks 

    Atef Abdelwahed 

    Supposing you're talking about getting data from a Azure SQL Database in Power BI desktop, you can click "get data"->"Azure"->"Microsoft Azure SQL Database", and fill the Server and database as what you fill in SSMS.

     

    As to sign up Power BI, it can be all free. Check Self-service sign up for Power BI.

    • atefaly01's avatar
      atefaly01
      Regular Visitor
      9 years ago

      I know and already done but couldn't get my data.

      The issue is that the accepted sign up to Power BI should be with work email 

      while I worked on Azure with my gmail sign in.

      So get data return error of access 

      The error details

      Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        9 years ago
        atefaly01 wrote:

        I know and already done but couldn't get my data.

        The issue is that the accepted sign up to Power BI should be with work email 

        while I worked on Azure with my gmail sign in.

        So get data return error of access 

        The error details

        Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

        I'm confused how you connect to Azure SQL database. Can you check this page? It shows how to connect to Azure SQL DB from SSMS. You connect to Azure SQL DB with the same user/password as in that demo.