Connecting to Internal Company SQL Server from Powerapps using Windows Authentication

Hello,

I have been trying to connect a SQL database to my Canvas app as part of a feature that autocompletes a form based on user data. The SQL server I plan on using is closed access and as such only specifically authorized Windows accounts (including my own company account) would be allowed to query/connect. It is mentioned here: Use Microsoft SQL Server securely with Power Apps - Power Apps | Microsoft Learn that Windows Authentication can be done implicitly (No Credentials for an App User Required) meaning I can serve other users of my app with my own SQL data access. How can this be setup? Whenever I try to make a new connection to said server and set the authentication mode to Windows authentication, it asks for specific credentials and for a gateway. Where would I go from here to set things up? Company policy forbids me from 'installing' a gateway onto my pc, but ideally I would want this connection to run completely in the cloud (with Windows Authentication to my account of course). Attached is an image of the new connection.

Categories:

Dataflows

Connecting to Data

Connectors