Connecting to a SharePoint (Teams) Folder fails authentication

Question

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?

amirabedh · Accepted Answer

Have you tried to connect with your Microsoft account ?

Here is an old thread :

Forum Discussion