AAD Authentication for SQL Server

[vamshikrishna20]

Hello Everyone, 

I am trying to connect Power BI to Azure Sql Server and i had a Active directory service account for this. I tried using these credentials in Database Quthentication but it throws error as "Cannot open the server xxxx.com". can someone help me how do i implement AAD authentication for sql server in Power BI. 

Thanks in Advance

[NandanHegde]

Please try clearning the cache

This would pop up the UI to input your AAD account.

Can you provide screenshot w.r.t your issue in MSFT account auth?

[NandanHegde]

Hey,

Can you please provide some screenshots w.r.t how you are accessing the Azure SQL DB from powerbi and what values you are providing in the connection details?

Note: Please scrub any sensitive data before posting in forum

[vamshikrishna20]

@NandanHegde , Providing the snippets below:

S-1: Navigating to Azure sql connector and providing the Server and db details

S-2 : In authentication, selecting database and providing service account details provided by DB Team.

S-3: Error snippet

[NandanHegde]

Hey,

Please use the Microsoft account and not database (since that is for SQL auth only) since you are using AAD account

[vamshikrishna20]

@NandanHegde ,

when i use microsoft account, it is by default taking my windows user id even after trying with signin as different user option