Forum Discussion
Failed to update data source credentials:
General update for others who might come across this post with a similar issue. Because I am linking to an on-premise SharePoint site I had to install Microsoft Power BI Gateway and add the Sharepoint source there first. This allows the dataset on PowerBI Service to refresh using the credentials provided by the connected gateway. Below gateway documentation for as a reference. I tested and this has solved my issue.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle
Add a data source
You can add a data source by either selecting a gateway and click Add data source, or go to Gateway > Add data source.
You can then select the Data Source Type from the list.
Please select Sharepoint List(on-premises) instead of oracle.
Community SupportHi Mvanruys
the report file (.pbix) itself is stored on OneDrive, its original datasource is a Sharepoint list.
When you refresh the report file (.pbix) using Power BI Desktop, it would refresh data from Sharepoint directly.
But, if you connect to OneDrive from Power BI Service,then configure for schedule refresh, it would refresh from OneDrive, so you need to provide the credential of OneDrive instead of Sharepoint.
Best Regards
Maggie