Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Helper III
3 years ago

AAD Authentication for SQL Server

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

Need Help

5 Replies

  • NandanHegde's avatar
    NandanHegde
    Super User
    3 years ago

    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's avatar
      vamshikrishna20
      Helper III
      3 years ago

      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's avatar
        NandanHegde
        Super User
        3 years ago

        Hey,

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

  • NandanHegde's avatar
    NandanHegde
    Super User
    3 years ago

    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?