Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Connecting powerquery excel report file to sharepoint folder which requires MFA

I want to connect my excel file to a data source folder that is on company's site and requires MFA.

I can keep the excel on the sharepoint too. Please suggest some ways so I can keep it there and everyone in team can access it without issues. or without requiring to enter password again n again.

Thanks in advance.

BA_Pete tagging you in case you can help me here.

General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    The only way to avoid that is to switch off MFA.  If you have MFA you are stuck. See if you can still use service principals without MFA in your company.