Forum Discussion
Fabric Pipeline is throwing User Auth Fail error
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.
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.
6 Replies
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.
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?
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.
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!
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.
