I have created a connection to an on prem sqlserver database using our gateway.
What intrigues me is that I have to use a fixed account and password in defining the connection.
I would have expected that The credentials used will be taken from the current user of the power app.
That way security could be imposed on the data delivered to powerapps.
Am i mistaken or is this something to be expected in the future?
Thanks in advance, Michael