Forum Discussion

Mvanruys's avatar
Mvanruys
Frequent Visitor
7 years ago
Solved

Failed to update data source credentials:

Hi   I have been having an issue in PowerBI Service where I am unable to set up a scheduled refresh. I keep getting an error message telling me that it failed to update the data source credentials ...
  • Mvanruys's avatar
    Mvanruys
    7 years ago

    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.