cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to DB connection (cloud and on-prem) as user

There is an existing PowerBI idea - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13099824-enterprise-gateway-on-pr... - that suggests making the Enterprise Gateway use authenticate as user for on-prem sources so that row-level security is maintained. This would also be great for cloud DB sources like Azure SQL DB since it also supports row-level security. If a service or general account is used to connect to those data sources than the business application has to implement some security at that layer and doesn't allow the business app to build on already existing (and maintained) security that has been implemented.

Status: Under Review
Comments
Audrie-MSFT
Power Automate
Status changed to: Under Review
 
jasjitchopra
New Member

Any possibility of connecting to Azure SQL DB via Azure AD Login of the powerapp user itself seemlessy within powerapps?

 

Do you have any ETA on this?

Eric503
Frequent Visitor

Has anyone found a work-around that allows PowerApps to use AzureAD authentication for connetions to SQL Azure Database?

MrHesson
Advocate II

@Audrie-MSFT any updates on the status of this or even a suggestion on how to implement this with a custom connector?