Skip to main content

    Power BI

    New

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

    Vote (21) 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

    aa841ad5 599e-429f-b4f1-dd3948bc17df 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

    481f6e57 09ce-4838-b13a-5d43c5baa4ea 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