The credentials provided for the SharePoint source are invalid.

[Anonymous]

For some reason when I update via app.powerbi.com I keep getting the error: 

The credentials provided for the SharePoint source are invalid. 

I have gone into the credentials section and changed the login from Annonmous to Auth2 and used my login creditnals. It seems to "take" Then when I go back in to update the dataset i get the same message. For some reason the credentials are not saving. 

Has anyone seen this? Any tips? 

[Josh_BI_UK]

Hi @v-jiascu-msft , I tried your link, however it doesn't point to any specific help page. Just the general Power BI Support site.
 
"The engineers are working on the fix. Please refer to the https://powerbi.microsoft.com/en-us/support/.  "
 
Do you have a specific URL to the info you are referring to as I’m receiving the same error message on my on-prem Power BI server?
 
Background:
Environment: On-Premises
Data connections: 1x Odata Connection & 1 x SharePoint List Connection

It quite strange because when I manually refresh the report, via the report option drop down > Manage > Scheduled Refresh > Refresh Now  (see image below marked A) , the report refreshes fine. (see image below marked B).
 

Power BI Report Server - Manual Refresh

 
 I have also tested the Data source connections credentials and they are fine too.
 

Power BI Report Server – Data sources connections

 
Details of my error below:

An error has occurred.

Several errors occured during data refresh. Please try again later or contact your administrator.

Hide error details    SessionID: xxxxxx-49aa-xxxxx-912c-xxxxxxxxxx

[0] -1055784934: The credentials provided for the SharePoint source are invalid. (Source at https://mysite.com/sites/examplelist.). The exception was raised by the IDataReader interface.

[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[8] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[9] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[10] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[11] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[12] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

[13] -1055784934: The command has been canceled.. The exception was raised by the IDataReader interface.

[14] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

Power BI Report Server - Refresh Error

[Anonymous]

I have same problem. 

Are you found any solution?

[steadyFox]

Hi, we're having the same issue. Any updates? 

[v-jiascu-msft]

Hi @steadyFox,

Please refer to the Awareness in the support page.

Best Regards,
Dale

[nkintanar80]

Hello,

I also have this issue and it started yesterday.  Any report with SharePoint credentials will not update in the portal, but I can refresh it on the desktop.   The credentials have not changed, and reentering them on the portal has not helped.  I also tried readding credentials on the desktop and publishing, but that did not work.    Lets hope we can find the solution soon!

Thanks!

Nick

[Kil0]

 I am receiving a similar error when the published report refreshes. The errors started this morning on two reports that utilize a SharePoint data source. No change to the data source on SharePoint, no change to the report, and the report refreshes completely with no errors using latest desktop version. 

[v-jiascu-msft]

Hi @Anonymous,

Can you share the details of the error message? Especially the "Activity ID". Please refer to the snapshot below. It's good. 

Best Regards,
Dale

[Anonymous]

This is the error that I get. 

Thanks for any help! Superfrustrating when it was up and running without errors for so long then all of a sudden it stoped and strated doing this. 

[Anonymous]

I have the same problem as Frunkis, The problem appered about a week ago.

Message:            The credentials provided for the SharePoint source are invalid. (Source at https://alawar-my.sharepoint.com/.....) Table: Query Select WishList Tables.

Cluster URI:        WABI-WEST-EUROPE-redirect.analysis.windows.net

Activity ID:          16a229e5-5f84-444d-b324-2dee2881de80

Request ID:        3edf7147-6303-43d1-88a6-d04d9cc76a28

Time:    2018-11-09 01:11:12Z

[v-jiascu-msft]

Hi All,

A similar issue has been reported. I will update the progress here. For the internal reference: CRI 91180988.

Best Regards,
Dale

[Anonymous]

Dale, Any updates on this? 

[Anonymous]

I really need some help in this... I have been able to refresh via the desktop version but the auto updates are not working at all. This is cripling the reports. I saw a bunch of posts from back in 2016 and 2017 where the same issues were reported and it was on the MS end.... is it possible that the same type of thing is happening now? Anyone else seeing issues  with connecting to a sharepoint folder?