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

    d9718d85 849f-4e57-b18c-5df74d1a860f 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

    439906d0 138b-439d-b7be-c0dd1510c1f7 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

    f472a73c d3b7-476d-a158-baae7fa6f101 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

    58088b71 bf15-4b9c-95a6-b585d531994e 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

    f0926dd8 97f0-403b-b587-488dcf2471f3 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

    1895225d 29da-4b07-b321-393bd1478ffd 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

    3b87da8c b27e-4540-90ad-77c20cb8f988 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

    2d353956 3026-46ad-ab1a-1ca5d55f124c 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

    f0926dd8 97f0-403b-b587-488dcf2471f3 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 !

    Neil Palmer's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:07:22

    RE: SQL Azure connector with Azure AD Auth

    This is essential for us!