Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

connect PowerBI to Azure SQL using Azure AD authentication.

Hi, We have created Azure SQL database and added AD group which allows us to connect using Azure AD authentication using SSMS. When we tried to connect from PowerBI desktop to same database using...
Reports
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Qiuyun,

     

    Thanks for the response, But here I have created Azure SQL database and added AD group which allows us to connect using Azure AD authentication using SSMS.

     

    Now i would like to know if its possible now on how to connect PowerBI to Azure SQL using Azure AD authentication.

     

    Thanks,
    Ankit

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      8 years ago

      Hi Anonymous,

       

      As you can see from the blog shared in my previous post, it's able to use AAD accounts to authenticate Azure SQL database. Please update your Power BI desktop to the latest version then test again with Microsoft Account option. 

       

      Best Regards,
      Qiuyun Yu 

      • Eric503's avatar
        Eric503
        Regular Visitor
        8 years ago

        How do I sign in with a Microsoft Account to authenticate with Azure AD?  I'm using Desktop Version: 2.57.5068.501 64-bit (April 2018) and when I select Home->Get Data->More->Azure->Azure SQL Database, I only get the ability to enter the Server Name and Database(optional). This of course fails.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Or ignore my previous comment, here are the steps we are following:

    Added AD users (for example [email protected]) to the database.
    Added firewall to network (breakout IP).
    Installed SSMS on computer and connect to database using Azure Active Directory Authentication (AAD Authentication).
    Successfully connect.
    Then installed PowerBI Desktop on same pc.
    Tried to connect to same database using PowerBI without SQL authentication (username/password), but failed.

    The authentication we have is Windows and Database and we are using Windows authentication. Please let me know if we are doing something wrong.