Failed to test the connection to your data source. Please retry your credentials. sharepoint

[enath]

I have a dataset with a sharepoint connection.
I try to set up a schedule refresh
but I got this error when I edite de credential.

What should I do?

Many Thanks

[Anupa_Jayakody]

Hi, my data source is a One Drive folder, and this error comes, how to solve

Failed to test the connection to your data source. Please retry your credentials

[Loisp]

I am also experiencing the same problem. 

I have tried all the alternative solutions found in the forum but nothing worked. I have tried to clear the credentials and try again, update the Power BI to the latest version, clear cache, and also go to options-> security -> authentication browser -> use my default browser.

I would be glad if anyone have sorted this problem and can assist me.

Thanks in advance.

[enath · Accepted solution]

Many others credentials that were saved...

You can remove the failing data sources in data source setting. You can replace the failing data source by the one from sharepoint and then it worked to me. 

[Loisp]

Hello enath,

I tried already to clear the credentials but it didn't work. 

Similarly with me, my colleagues cannot also import data from SharePoint so I believe that this is a general problem.

[enath]

I also tried to do a new report from scratsh where I connect the power BI via sharepoint list. On the new and clean report it did worked. You need the url from the data in sharepoint and to put it as a parameter of the quierry 

[jcalheir]

First make sure the user you are authenticating has a valid credential to the specific Sharepoint Location.

Then try to edit credentials in Power Query then publish to PBI Service:

In PowerQuery chose "Data Source Settings", select your Source, click in "Edit Permissions" and provide a valid one.

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Anonymous]

Hello ,

I am facing the same issue but I am not able to get the data refresh. My data is saved on Teams(Sharepoint) and connected with pbix file. When I published it and clicked refresh it gave me the same error.I did edit teh connections but nothing works. Please advice. I have attached screenshot of error.

Thank You

[enath]

Thanks a lot, I had to completly remove the other data source in order to make it work.