Power Query Excel - connect to SharePoint folder

[rjsnl]

Dear all,

I built a Power Query connected to a SharePoint folder. I logged in with my credentials and that worked for a short while, but now I get the following message: We couldn't authenticate with the credentials provided. Please try again.

I have tried again and again. I've deleted the credentials in the settings and added them again. But nothing works.

Does someone have a solution to solve this?

[MohamedGadAllah]

This link has a solution for an almost identical problem.
https://powerusers.microsoft.com/t5/...t/true#M101819

1. Open the Excel file in your web browser

2. Select the option to open the file in the Excel application

3. When the file is opened in Excel, go to File>Information, and once in there, copy the access route of the file

4. Once you've copied that link, use it to connect Power BI to your data source. You will see that this fixes the authentication problem.