Ability to allow users to use on-premises data gateway with Power Platform dataflows without granting admin Permissions on gateway.

As per the case 120021724003738, MS support team suggested to grant Admin access for users would want to use an on-premises data gateway with Power Platform Dataflows to transfer quickly and securely between a Power Platform dataflow and a data source that isn't in the cloud, such as an on-premises SQL Server database or an on-premises SharePoint site

Link :https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/using-dataflows-with-on-premises-data#prerequisites

However we can’t setup users with Admin access due to the risk and the data security issues.

Request you to come up with a better solution where we don't need to grant ADMIN permission on the On-prem gateway