Fabric Pipeline is throwing User Auth Fail error

[digitalbrain]

Hello MS community, I'm getting "UserAuthFailedToGetToken" error in the pipeline on Lookup activity that calls data warehouse SP. It started happening after Admin enabled MFA on the user account who has created the pipeline. I'm suspecting MFA somehow causing the issue. Could you please let me know why this is happening and how it could be resolved.

ErrorCode=UserAuthFailedToGetToken,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to get User Auth access token. The error message is: Failed to get User Auth access token. The error message is: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access. 

[digitalbrain · Accepted solution]

Thank you everyone for sharing your thoughts. The resolution is to copy-rename/recreate the pipelines that are already created before MFA was enabled. For some reason, the old pipleines started throwing 'UserAuthFailedToGetToken' error, however, they work fine if you save as or recreate them without changing anything. I'm assuming this is something to do with Fabric's backend authentication, which was affected due to MFA policy.

[tharunkumarRTK]

@digitalbrain 

Have you tried floowing all the options suggested in this video

https://www.youtube.com/watch?v=QI_5MD9qY2k

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[FabianSchut]

Hi @digitalbrain,

Could you tru to edit the connection in the 'manage connections and gateways' settings?

In here you should be able to see the connected you are using listed. If you click on the three dots and click settings, you are able to choose an authentication method. Please sign in again with the account that has 2FA enabled.

[digitalbrain]

Hi @FabianSchut, I already tried that option. The fabric warehouse connection does not show up there. Do you know where else can I see that connection?

[FabianSchut]

Hi @digitalbrain, I think the connection is not showing up there because the person who created the connection did not gave you access to that connection. You could ask him/her to provide you access to that connection. Otherwise, you could try to create a new connection yourself using your own credentials and use that in the pipeline.

[digitalbrain]

It's a data warehouse that is created inside fabric. I think it won't show up there as I'm the owner and I can't see it. Could you please share the screenshot if its connection is visible at your end?