CODEWITHSUNDEEP
azure-sql-databasepowerbipowerbi-datasource
LordRofticus
LordRofticus

Reputation: 237

PowerBI using AD

I am trying connect to Azure SQL database with PowerBI using AD Authentication. Basically we want users of the PowerBI report to use their own AD credentials when they connect to the database.

Using windows authentication I can connect to the Azure SQL via SSMS. But when I try the exact same way via PowerBI its says "user was not authorized" PowerBI Login

I have on Azure SQL Server created a AD user (FROM EXTERNAL) that is my AD User. SSMS

Am I missing something?

Upvotes: 1

Views: 764

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15698

Please ensure firewall rules for the SQL Azure database are configured to "Allow access to Azure services".

Currently Power BI doesn’t support AAD authentication when connecting to Azure SQL Database, but using Microsoft ODBC Driver 13 it is possible to do it as explained here.

ODBC (for AD PW Auth; must have ODBC Drive 13 for SQL Server) 
Driver={ODBC Driver 13 for SQL Server};Server=<servernamehere>;Database=<databasenamehere>;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryPassword

Upvotes: 1

Related Questions