Forum Discussion

DataMinion's avatar
DataMinion
Icon for Helper I rankHelper I
3 years ago
Solved

We couldn't authenticate with the credential provided. Please try again

Hi,   I'm using Power Query via Excel and not via Power BI. I have various spreadsheets saved in Sharepoint that I connect to and all of a sudden when trying to refresh one I get the message to 'Ed...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Steve,

     

    Have you tried narrowing the level at which you apply the credentials? The dropdown box in your screenshot shows that you're trying to auth at the SharePoint root level and, unless you're a top-level tenant admin, it's unlikely you have auth to access this level.

    Try authenticating at the next level down, then the next level after that, and so on.

     

    Pete

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

I found a solution, execute the follwing steps:

1. Open de excel file in your web browser

2. Select the option to open de file in 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 in power BI your data source. You will see that this fixes de authentication problem.

 

I hope it works for you as it worked for me!

 

 

NordSyd's avatar
NordSyd
Frequent Visitor
2 years ago

This worked for me. Thank you for the solution!

Related content