Can not authenticate using the given information for a Sharepoint Folder

[Anonymous]

Hi everyone,

I have an issue connecting to one of my Sharepoint folder source on Power Query for Excel and Power BI to update the data.

I am using an organizational account.

The authentification information is correct and works for the other folders, but not for this one, so i can not update my data.

I have tried clearing the cache : Solved: Re: Invalid Credentials when connecting to SharePo... - Microsoft Fabric Community for Power BI but it didn't work.

I have reconnected my source in File >Options & Parameters > Parameters of the data source in Power Query - Excel and it works there, but I still get the error message after I try to reconnect the source again.

[Anonymous]

Hi @Anonymous ,

1. Use the Correct Site URL: When connecting to a SharePoint site, you’ll be asked to enter the site URL. You can usually get the site address by selecting Home in the navigation pane, or the icon for the site at the top.
Power Query SharePoint folder connector - Power Query | Microsoft Learn

2. Go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint, click "clear permissions" , then connect to the data using SharePoint folder connector again.

3. Change Default Browser: One user reported that changing their default browser to Chrome and adjusting Power BI settings (Settings > Security > Use my default web browser) resolved their issue.

Solved: Sharepoint authentication error "We couldn't authe... - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Daryl-Lynch-Bzy]

Hi @Anonymous - could you please show the Power Query formula that you are using to connect to SharePoint.  Is should look something like this:

Source = Sharepoint.Files( "https://{yourtenant}.sharepoint.com/{sitename}" , [ApiVersion=15] ) 

This function will show a complete list of documents in the Sharepoint site.  There is a list of folder path on the right end.  If you cannot see the SharePoint folder on this list, it must indicate that you don't have access to the Document Library.  This would be SharePoint library issue.