Unable to connect Power BI to Azure SQL DB

Question

1. I am using a service account (AD account sync’d with Azure AD) to connect to Azure SQL DB (Note: SQL account connection works but need AD account to work)
2. Service account ([email protected]) has ‘Read/Write’ access on Azure SQL DB
3. Service account connection works from (SQL studio) SSMS.

I am getting "Microsoft SQL: Cannot open server '@xyz.com' requested by the login. The login failed" error. I don't understand what I am I doing wrong here. The account has been created in DB, it has access and still it doesn't connect.

Answer 1

That server name is too short to be an Azure SQL Database.

It should be something like name.database.windows.net