Skip to main content

    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

    Nasreddine BENKHELIFA on 11 May 2021 16:43:37

    RE: SQL Azure connector with Azure AD Auth

    Still impossible de use Power BI with Azure AD authentication mode, any solution to this problem ?

    Neil Palmer's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:22:28

    RE: SQL Azure connector with Azure AD Auth

    I was unable to get this to work: https://community.powerbi.com/t5/Integrations-with-Files-and/Error-connecting-PowerBI-with-Azure-SQL-Database-with-Azure/td-p/440532

    Neil Palmer's profile image Profile Picture

    Kalpesh on 05 Jul 2020 23:18:02

    RE: SQL Azure connector with Azure AD Auth

    This feature only works for native AD users, it does not work for AD guest users. For AD guest users it is giving "We couldn't authenticate with the credentials provided. Please try again." even with the valid credentials.

    Neil Palmer's profile image Profile Picture

    Joost on 05 Jul 2020 23:16:33

    RE: SQL Azure connector with Azure AD Auth

    This is to connect PowerBi directly to your data.
    There is no way to connect PowerBi to my WebAPI that is secured by AzureAD.

    Neil Palmer's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:09:11

    RE: SQL Azure connector with Azure AD Auth

    Did you plan to integrate the same feature in Excel 2016 soon ?

    It seems Excel and PowerBI Destop use the connector, but I don't see the tab "Microsoft Account" in Excel...

    Neil Palmer's profile image Profile Picture

    Rudy Cortembert on 05 Jul 2020 23:09:10

    RE: SQL Azure connector with Azure AD Auth

    From the Jan-18 update page : "Note that support for this new authentication type in the Power BI service will come in a few weeks. Please stay tuned to this blog for updates on this capability."

    Please delete this misleading sentence. The feature is now available.

    Neil Palmer's profile image Profile Picture

    Mohammad on 05 Jul 2020 23:09:04

    RE: SQL Azure connector with Azure AD Auth

    This will be great

    Neil Palmer's profile image Profile Picture

    Michael McMaster on 05 Jul 2020 23:08:55

    RE: SQL Azure connector with Azure AD Auth

    Please provide an update on expected release date.

    Neil Palmer's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:08:43

    RE: SQL Azure connector with Azure AD Auth

    I'd love to figure out how to share PowerBI Apps that depend on DirectQuery, but it seems impractical without this feature.

    Neil Palmer's profile image Profile Picture

    Rudy Cortembert on 05 Jul 2020 23:07:53

    RE: SQL Azure connector with Azure AD Auth

    Power BI Desktop December now supports several 3rd party connectors but does not support Microsoft Azure AD Auth. Really strange !