Error: We couldn't autheticate with the credentials provided please try again

[smeetsh]

Hi All, When trying to refresh data from a power query that connects to a fabric warehouse we get the following error:
"We couldn't autheticate with the credentials provided please try again"

The credentials are correct and other users are able to use this excel sheet and its embedded query. I have already gone in and editted and later cleared the local workbook credentials, but that does not solve the error.

Does anyone have an idea?

Cheers

Hans

[Omid_Motamedise · Accepted solution]

The error "We couldn't authenticate with the credentials provided" often occurs in Power Query when there is an issue with how the credentials are being authenticated or managed in your local environment. If other users are able to use the same Excel sheet and query successfully, this points to a configuration issue specific to your system or account.

Make sure your account have the same access.

[smeetsh]

This was exactly the problem, we had to assign a free powerbi license, of which you have unlimited. Not quite sure how that works.

The last step was that i had to manualy clear the users credentials for that sheet , on his machine. That forced a login and solved the issue.

[Poojara_D12]

Hi @smeetsh 

To resolve the authentication error when refreshing data from Power Query in a Fabric warehouse:

1. Clear Cached Credentials:

   • Go to File > Options > Data > Edit Credentials in Excel, clear cached credentials, and re-enter the correct credentials.

2. Check Account Permissions:

   • Ensure your account has the necessary permissions in Azure AD or Power BI Service to access the Fabric warehouse.

3. Re-enter Credentials:

   • After clearing credentials, re-enter them and choose the correct authentication method (e.g., OAuth).

4. Check Power Query Settings:

   • Ensure the query is pointing to the correct warehouse and check the Data Source Settings in Power Query.

5. Network/Proxy Issues:

   • Make sure there are no network or proxy issues blocking authentication.

6. Sign Out and Back In:

   • Sign out of Excel and re-sign in with the correct account.

7. Check for Service Outages:

   • Verify if there are any service issues with Fabric or Azure.

These steps should help resolve the issue.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS