Forum Discussion
connect PowerBI to Azure SQL using Azure AD authentication.
Hi Anonymous,
When you connect to Azure SQL database, please choose Microsoft account option to sign in with your Azure Active Directory account. See: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#AADauth
Best Regards,
Qiuyun Yu
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.