Skip to main content

    Power BI

    New

    Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    Vote (37) Share
    John G Hohengarten's profile image

    John G Hohengarten on 24 Mar 2016 05:00:28

    For the Enterprise Gateway, when setting up an on-premises data source e.g. SQL Server, instead of explicitly specifying a Windows authenticated account, add a setting that just does "User current user" to pass on the DOMAIN\user credentials to the on-premise SQL Server.

    Similarly to the SSAS implementation of using current user.

    The primary use-case in mind is for usage with SQL 2016 Row Level Security, and to allow users to only see data relevant to them on their dashboards and reports, with either Imported or Direct Query.

    Comments (6)
    John G Hohengarten's profile image Profile Picture

    fb00e222 354f-44a8-889c-c5eaa43b7f6b on 05 Jul 2020 23:16:27

    RE: Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    This would be a great feature.....but I see the initial idea was logged in 2016 with no update yet.

    John G Hohengarten's profile image Profile Picture

    23829ea9 271b-49ff-b7e1-df50fed2b62d on 05 Jul 2020 23:10:13

    RE: Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    I'd like to be able to setup a connection, even ODBC, where users of that connection provide their own credentials per Dataset. For example you may have a DB2 Subsystem with a thousand databases/Schemas. I'd prefer to create a generic ODBC DSN (all our users have those installed) and when the user sets a refresh, must input user credentials

    John G Hohengarten's profile image Profile Picture

    4e1c8e66 d973-43b8-b95c-18cd7bdaa973 on 05 Jul 2020 22:42:47

    RE: Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    Also to allow UPN Mapping as with AS datasources

    John G Hohengarten's profile image Profile Picture

    7230b5f1 0986-4e42-97c8-bbbf44b0bc59 on 05 Jul 2020 22:25:26

    RE: Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    This would be a great idea - but hopefully wouldn't be limited to on-prem connections. SQL Azure DB connections to Power BI and Powerapps would also benefit from being able to connect as current user (which using Azure AD - should work really well)

    John G Hohengarten's profile image Profile Picture

    b9499e29 98ce-4883-aabc-8795c32a2174 on 05 Jul 2020 22:22:39

    RE: Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    Indeed a very desirable feature!

    John G Hohengarten's profile image Profile Picture

    4534cc51 af30-42ed-9ded-bd6ca6d3fc5d on 05 Jul 2020 22:18:01

    RE: Enterprise Gateway On-Premises SQL Server Credentials - Use currently logged-in DOMAIN\user

    Typo: "User current user" should say "Use current User"