Power BI

Completed

SQL Azure connector with Azure AD Auth

Vote (435)

Neil Palmer on 12 Oct 2015 18:02:41

Update the SQL Azure connector to use Azure AD Auth. This will allow row level security in the database to be used with PowerBI.

It would be great to have PowerBI pass through user credentials to the database so that data can be kept secure.

Administrator on 10 Jan 2018 02:01:06

This feature has shipped in the January 2018 update for Power BI Desktop. Please refer to the official announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#AADauth

Comments (62)

Comments (62)

41f3dba9 6753-4bc4-b6d7-7070ae7ae164 on 05 Jul 2020 23:02:45

RE: SQL Azure connector with Azure AD Auth

Does Power BI Desktop/Azure SQL DB work with Integrated AD Authentication yet? There's a lot of conflicting information out there and we have a project to complete. Many thanks.

02d912eb 01cd-49db-bbf5-7c8fd34a8fc2 on 05 Jul 2020 23:01:48

RE: SQL Azure connector with Azure AD Auth

lifesaver:
https://blogs.msdn.microsoft.com/azuresqldbsupport/2017/04/06/connect-from-power-bi-to-azure-sql-database-using-aad-authentication/

I have tested this, it is excruciating. It is basically Power Query. You have the same issues connecting to Azure SQL DB in Excel. I love the idea of Azure SQL Database, no VM needed. However, connectivity, again, is excruciating. This isn't a solution, but a work around for those that need it. You need the flipping ODBC Driver, but it works if you have a newer install of Windows, SQL etc...

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

OLEDB (SQL Server Authentication Only):
provider=SQLNCLI11.1;initial catalog=;data source=;auto translate=False

Also, for SSMS, use Azure AD PASSWORD AUTHENTICATION! Good Luck!

7d3e82c2 0200-4b5b-817b-df747696db9e on 05 Jul 2020 23:00:58

RE: SQL Azure connector with Azure AD Auth

Can we get an update on this feature?

287499e5 d822-4ed1-9885-5886a36ef8c0 on 05 Jul 2020 23:00:09

RE: SQL Azure connector with Azure AD Auth

Pass through AzureAD credentials are a must to support direct query database RLS with views that protect the data using the original_login () TSQL function. It allows us to build centralized robust RLS that reside on the server itself.

Implementing this in PowerBI is not what we want to in an enterprise setup.