How to connect to azure sql database?

[Anonymous]

I have a remote Azure SQL database i would like to connect to (different email adressed linked to it). I am struggling to connect to the database as a source.

1. When entering credentials - is it the credentials that are used to log in to Azure? Or the credentials to access the database? As they are typically two different logins.

2. Is is not possible to access using a connection string? 

[negi007 · Accepted solution]

@Anonymous there are various ways to connect to Azure SQL DB. In below links you can find more detailed description in connecting to Azure SQL DB

https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabase

https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect

https://www.mssqltips.com/sqlservertip/5953/create-power-bi-connection-to-azure-sql-database/

[aj1973]

Hi @Anonymous 

1- it is the credential to login to Azure but also the permission to access the DB.

2- You will need an API.