Skip to main content
Microsoft Idea

    Power BI

    Completed

    SQL Azure connector with Azure AD Auth

    Vote (435) Share
    Neil Palmer's profile image

    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 (63)
    Neil Palmer's profile image Profile Picture

    Travis Tittle on 05 Jul 2020 22:25:46

    RE: SQL Azure connector with Azure AD Auth

    This implementation may be what slows us on the Azure SQL Data Warehouse. Looking forward to the Azure AD Auth!

    Neil Palmer's profile image Profile Picture

    Jan Cordtz on 05 Jul 2020 22:22:28

    RE: SQL Azure connector with Azure AD Auth

    Would be a very important capability to support different databases row-level security option.

    Neil Palmer's profile image Profile Picture

    Gajendra on 05 Jul 2020 22:18:24

    RE: SQL Azure connector with Azure AD Auth

    Agreed with the idea. As SQL Azure Database itself is ready to implement stringent security requirements (AAD auth, RLS etc.), Power BI should start adding support for these.