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
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.

ivan_wilson's avatar
ivan_wilson
Regular Visitor
7 years ago

I'm having a similar issue. I'm using the March 2019 version of Power BI desktop. I'm able to authenticate to the Azure SQL database using my Windows credentials in Excel. When I try to use the "Microsoft Account" option to sign in from Power BI Desktop, I get the error "we couldn't authenticate with the credentials provided" when I click Connect.

 

We are using Multi Factor Authentication with our Azure Active Directory. When I click the "sign in" button in the Power BI Microsoft Account page, it takes me through the two-factor auth process and displays that I am signed in. However I still get an error when I click the Connect button.

  • tonmcg's avatar
    tonmcg
    Resolver II
    6 years ago

    I'm having the same issue and can't find a resolution. Does anyone know how to fix this?