Skip to main content

    Power BI

    Needs Votes

    Active Directory/Microsoft Account authentication in Power BI Gateway for SQL Server

    Vote (30) Share
    S M Atiqur Rahman's profile image

    S M Atiqur Rahman on 30 May 2019 12:44:11

    To setup SQL Server (Azure SQL Managed Instance) datasources in Power BI gateway, we have two authentication methods: Windows, Basic. There is no option for Organizational Accounts/Active Directory/Microsoft Account.

    Please introduce this, as we are trying to limit SQL user access, and rather rely on Active Directory

    Comments (2)
    S M Atiqur Rahman's profile image Profile Picture

    andrew on 06 Jul 2020 00:08:45

    RE: Active Directory/Microsoft Account authentication in Power BI Gateway for SQL Server

    'its is very much not recomended "best practice" to use hard coded username/password combinations. I am disappointed that our options are :
    - don't use powerbi server,
    - don't use azure sql server, or
    - accept poorly audited connections from whoever happens to get the username/password pair.

    S M Atiqur Rahman's profile image Profile Picture

    ADNAN AHMED on 06 Jul 2020 00:04:25

    RE: Active Directory/Microsoft Account authentication in Power BI Gateway for SQL Server

    I recommend this option to be a part of Power BI