How can we improve Power BI?

SQL Azure connector with Azure AD Auth

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.

437 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Neil Palmer shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

62 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Kalpesh commented  ·   ·  Flag as inappropriate

    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.

  • Joost commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

    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...

  • RudyCo commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • RudyCo commented  ·   ·  Flag as inappropriate

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

  • Ryan Schofield commented  ·   ·  Flag as inappropriate

    Add me to the list of those disappointed that this is not in the December update. This is significantly impeding adoption of Power BI Desktop for a company I work with. I told them to expect it by the end of year, but now I have no idea as to what I should tell them.

  • Corey Kropp commented  ·   ·  Flag as inappropriate

    Please provide an update on this feature. Unfortunately, it didn't make the December 2017 release.

  • David commented  ·   ·  Flag as inappropriate

    Apparently this hasn't made the December release either. So not CY17, is there a new estimate?

  • Allan commented  ·   ·  Flag as inappropriate

    Makes no sense that this isnt supported!! when will it be released?

  • Justin commented  ·   ·  Flag as inappropriate

    Also a +1. My whole team is building reports off a data source that uses Azure AD, so this is a must have.

  • RudyCo commented  ·   ·  Flag as inappropriate

    This is must have !
    Hope it will be released before Xmas as a present from Santa !

  • Anonymous commented  ·   ·  Flag as inappropriate

    Since this didn't make it into the Nov 2017 release, will it definitely make the Dec 2017 release?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Since this didn't make the Nov 2017 release, will we definitely see in the Dec 2017 release?

← Previous 1 3 4

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.