Forum Discussion
The last refresh attempt failed - The credentials provided for the SharePoint source are invalid
Hi,
I have developed a dashboard in Power BI Desktop version and uploaded into Power BI through "Get Data" file option. The datasource is a sharepoint list. It is working perfectly alright in desktop version, but not getting refresh in power BI online version. Following are some error messages. I have installed personal gateway as well because the original file is saved on my desktop. I am certain that it doesn't need any gateway, but I have installed it just in case. Our sharepoint is cloud based.
The credentials provided for the SharePoint source are invalid. (Source at https://xxxxxxx.sharepoint.com/_api/Web/Lists(guid'345d04d9-3c23-4eb4-abdd-899e18b0195b')/Items(8103)/Author.)
The credentials provided for the SharePoint source are invalid. (Source at https://xxxxxxx.sharepoint.com/_api/Web/Lists(guid'345d04d9-3c23-4eb4-abdd-899e18b0195b')/Items(8078)/File.)
The credentials provided for the SharePoint source are invalid. (Source at https://xxxxxxx.sharepoint.com/_api/Web/Lists(guid'345d04d9-3c23-4eb4-abdd-899e18b0195b')/Items(8132)/FieldValuesAsText.)\
Any help will be appreciated.
Regards,
Tehsin Khan
13 Replies
Some customers that have more than 1,000 documents in a Sharepoint Document Library may experience issues refreshing reports when using Sharepoint Online as the data source. As a workaround, customers can refresh from Power BI desktop. Engineers will be deploying a fix starting 11/12 and expect it to be in all regions by end-of-day 11/17. Next update @ 11/16/18 at 5:00pm PST.
The issue is already resolved. However, if you are still facing the same, try to decrease the number of files of sharepoint. It will work fine if you'll have less than 1000 files on sharepoint
VelesAdvocate V
Thanks for the update. We've just started encountering this issue.
We've just started splitting out our datasets into separate document libraries to keep them under 1000 items while the fix is being deployed.
- Nhallquist
Helper V
Since your Sharepoint instance is cloud based, is it in the same domain as your PowerBI? have you tried insterting the Domain Name infrom of your username for Authentication, like Domain\Username? That one has gotten me a few times.
I am experiencing the same issue connecting to CRM. Did you find a solution to this as it may help me also?
I also am haveing this issue. The desktop version authenticates fine. When I try to refresh the data online. I see "your data source can't be refreshed because the credentials are invalid. When I edti the credentials and I use the authentication method of OAuth2. the authentication fails and returns to anonymous. I am using https in the connection, to a sharepoint online list.
Failed to update data source credentials: Hide details
Activity ID: 366cde8b-bd06-7d94-8632-b535d77ac775 Request ID: 01386c13-57d7-17d1-929a-c5b5009b7388 Status code: 400 Time: Fri Jul 28 2017 11:02:43 GMT-0400 (Eastern Daylight Time) Version: 13.0.1930.145 Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net - prathy
Advocate III
Hi all,
Any update on this? I am facing the same issue?Thanks,
Prathy
Any updated on this???? Same issue here too!!
- Try clearing the cache and re enter your credentials. If you are using your organisational login, make sure your password is not expired.
