Skip to main content

How to Connect to your rSQL Database

Connecting Excel or Power BI to SQL Server

Excel: Connect Using SQL Login

  1. In Excel, go to the Data tab and select Get Data

  2. Choose From Database → From SQL Server Database

  3. In the SQL Server database dialog:

    • Server: enter your server name
      Example: {mysqlserver}.database.windows.net

    • Database (optional): enter your database name
      Example: Access2ZoneDW

  4. If prompted for authentication:

    • Choose Database

    • Enter your SQL credentials:

      • User name: your SQL login

      • Password: your password

  5. Click Connect

  6. You should now see available tables and views.

Excel: Connect Using Azure Entra ID (Microsoft Account)

  1. In Excel, go to the Data tab and select Get Data

  2. Choose From Database → From SQL Server Database

  3. In the SQL Server database dialog:

    • Server: enter your server name
      Example: {mysqlserver}.database.windows.net

    • Database (optional): enter your database name
      Example: Access2ZoneDW

  4. If prompted for authentication:

    • Choose Microsoft Account

    • If you see a “You aren’t signed in” message, click Sign in

    • Choose your company account or sign in

  5. Click Connect

  6. You should now see available tables and views.

Power BI: Connect Using SQL Login

  1. In Power BI, click Get Data

  2. Select SQL Server

  3. In the SQL Server database dialog:

    • Server: enter your server name
      Example: {mysqlserver}.database.windows.net

    • Database (optional): enter your database name
      Example: Access2ZoneDW

  4. If prompted for authentication:

    • Choose Database

    • Enter your SQL credentials:

      • User name: your SQL login

      • Password: your password

  5. Click Connect

  6. You should now see available tables and views.

Power BI: Connect Using Azure Entra ID (Microsoft Account)

  1. In Power BI, click Get Data

  2. Select SQL Server

  3. In the SQL Server database dialog:

    • Server: enter your server name
      Example: {mysqlserver}.database.windows.net

    • Database (optional): enter your database name
      Example: Access2ZoneDW

  4. If prompted for authentication:

    • Choose Microsoft Account

    • If you see a “You aren’t signed in” message, click Sign in

    • Choose your company account or sign in

  5. Click Connect

  6. You should now see available tables and views.

Was this article helpful?