Connecting to a SharePoint (Teams) Folder fails authentication

[IanDavies]

I have a bunch of csv files in a folder in teams that i wojld like to use as a source for queries in Power Query.

When I choose Sharepoint Folder as the source I get this box as expected:

I insert a URL which it accepts

but it won't authenticate

even though I can open the sharepoint site in a browser on the same PC usign SSO

I've tried manually entering creds as well and they still fail

any thoughts anyone?

[IanDavies]

Thank you - I had discounted Microsoft Account as an auth method that terminology normally means a personal account.

I am now connected, just not seeing the files i'd expect to see, but that's a question for another post

[AmiraBedh · Accepted solution]

Have you tried to connect with your Microsoft account ?

Here is an old thread :

https://community.fabric.microsoft.com/t5/Desktop/Authentication-Problems-with-SharePoint-Folders/td....