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...
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)/FieldValuesAs...\
Any help will be appreciated.
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
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.
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
|Time:||Fri Jul 28 2017 11:02:43 GMT-0400 (Eastern Daylight Time)|
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.