The credentials provided for the SharePoint source are invalid

[Anonymous]

I have a report which has several sources, like tables coming from Exasol and one tale is coming from SharePoint Online List. 

Now, I want to configure a data gateway to keep this report updated. I set a Gateway and it is working perfectly for the resources coming from Exasol or local file, but the table which is coming from a SharePoint list can not get configured. 

I receive the following error:

The credentials provided for the SharePoint source are invalid

I tried different combination as username, but none of them is working, I tried: 

Username

AzureAD\Username

Machinname\Username

Username@domai.com 

and so on. 

Does anyone know why I am receiving this error?

[Krishnakant123]

Hi All,

Im also facing same error "Failed to update data source credentials"

Is there any solution to reslove this issue

Anyone please help out to solve this issue

Thank you

[v-yuta-msft · Accepted solution]

@Anonymous ,

If you see the credentail error like below, you need to edit the sharepoint credentials and re-sign-in.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I find this solution somewhat lacking.

I have tried signing in and resigning out , editing the credentials, and I am still getting an error of "Failure to update data source credentials".

The reality is, this should work seamlessly between two microsoft services and it sure seems as if it does not.

[DebbieE]

we have the Same issue.

My colleague is added into the Sharepoint Site as a member

when they log into Power BI Service and attempt to resolve the issue we get this message

Are we missing something. Should member not be enough on the actual Sharepoint side we are using to store the data sources?