title: Unable to connect Power BI to Azure SQL DB
body: <ol>
  <li>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)</li>
  <li>Service account (abc@xyz.com) has ‘Read/Write’ access on Azure SQL DB</li>
  <li>Service account connection works from (SQL studio) SSMS.</li>
  </ol>
  <p>I am getting &quot;Microsoft SQL: Cannot open server '@xyz.com' requested by the login. The login failed&quot; 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.</p>
  <p><a href="https://i.stack.imgur.com/ZPLnl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZPLnl.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/8RTFX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8RTFX.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/RThRg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RThRg.png" alt="enter image description here" /></a></p>