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)
RE: SQL Azure connector with Azure AD Auth
'I came across this issue recently while trying to do the same with PowerBI. This is what I'm using until the team gets AAD support, you can replace the parts in with your values:
= AdoDotNet.Query("System.Data.SqlClient", "Server=;Initial Catalog=;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication=""Active Directory Integrated"";", "")
RE: SQL Azure connector with Azure AD Auth
Perhaps I should make a separate Power BI idea, but please support Azure SQL Data Warehouse with Azure AD Auth as well. It currently only supports Windows authentication which is not working for me (just like it doesn't work in SSMS either) and SQL authentication.
It looks like for now we need to create an Azure Analysis Services endpoint connected to our DBs using DirectQuery to get AAD authentication working.
RE: SQL Azure connector with Azure AD Auth
I can't believe this doesn't already exist. We need this ASAP as it has stopped us dead in our tracks!
RE: SQL Azure connector with Azure AD Auth
This has stopped us dead in our tracks on a Power BI / Azure SQL rollout for the company. Please prioritise the resolution asap.
RE: SQL Azure connector with Azure AD Auth
This is very necessary because we can't always allow access to databases using SQL Authentication. It's generally against our security policy.
RE: SQL Azure connector with Azure AD Auth
Please add this feature so I don't have to use sql auth.
RE: SQL Azure connector with Azure AD Auth
My use case is an updating dashboard accessing an Azure SQL database that has "open" data for all employees. Would like any authenticated user to access the DB for read so they can modify the dashboard, so just want to add the ['company' employees] group.
At present this doesn't seem to be possible because I have to access the database via database credentials.
RE: SQL Azure connector with Azure AD Auth
Is there any update on this as we want to use the feature within our application. Thanks
RE: SQL Azure connector with Azure AD Auth
Is this implemented yet? Two weeks ago we just found out that it is not possible to connect to an SQL Azure DB using AZURE AD credentials from Power BI/Excel.
RE: SQL Azure connector with Azure AD Auth
Any updates on support for Azure AD with Power BI?
I don't understand the issue, this is a connection string change, surely this is something that can be easily accommodated.
How can Microsoft's Power Business Intelligence solution not work with Microsoft's Best in Class data and authentication management solution, this is a big issue to me as I can't allow connections to my data any other way.