Power BI services do not recognize my credentials for SharePoint online
I create a list, that has been written manually in excel online and saved in oneDrive for business I have imported the data into PowerBI desktop with the SharePoint folder connector and created a PowerBI file which has been published to the PowerBI service and saved on OneDrive to allow the schedule refresh with the data sources.
These are my Data Sources
Everything works in power BI desktop and power BI services. (without a Gateway)
I don't have any suggestions, but just wanted to say you're not alone in noticing this.
We're having exactly the same problem at the moment - I have several CSVs and an XLS file in OneDrive for Business (using same account as my Power BI service account) which work perfectly from Power BI Desktop but we're seeing the "Failed to update Data Source Credentials" message from the Power BI Service after publishing to the web.
I've noticed a couple of other posts around the forum over the last few days regarding this, so hopefully someone will have a solution or workaround soon.