cancel
Showing results for 
Search instead for 
Did you mean: 

Add support for MFA to the SQL Server connector

The SQL Server connector does not currently support MFA, which means it's not possible to connect to another company's database if the company only allows this way of authenticating.


There are only four options for the Authentication Type in Power Apps, as opposed to SSMS which has an extra option of Azure Active Directory - Universal MFA.

 

Although it is possible to create a connection, there is no MFA challenge, and using the connection just gives a The tables didn't load error.

 

Power BI does seem to have a way of overcoming this. When setting up the connection for the first time in Power BI, the user must authenticate and after this the connection can be used thereafter. So it would be great if something similar could be done in Power Apps.

 

Status: New
Comments
ooyales
New Member

I had to switch to a non-Powerapps solution because I was given a SQL env with MFA-only.  It would be great to see 1) support for MFA to the SQL connector and 2) ETA when it can be released, if being considered.  Thanks.

4335Fdf
Regular Visitor

Facing the same issues, any updates?

tonyrogerson
New Member

With Azure AD default security settings now forcing MFA surely it's time for this feature to be implemented. 

4335Fdf
Regular Visitor

+1

rkaspers
Regular Visitor

+1