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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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.