Scheduled refresh failed because at least one data source is missing credentials

[Sabarish_Nandha]

scheduled refresh failed because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources.

Picture 1 : 

Picture 2 : Refresh history  picture 

My API Code:

var pbiReport = pbiClient.Reports.GetReportInGroup(workspaceId, reportId);
_logger.LoggingInformation("pbiClient.Reports.GetReportInGroup() => Report has been successfully fetched from the specified workspace and workspace,report id :" + "(" + workspaceId + " , " + reportId + ")", detailedLogInfo.Result);
var isRDLReport = String.IsNullOrEmpty(pbiReport.DatasetId);
if (!isRDLReport)
{

_logger.LoggingInformation("GetEmbedParams() => Fetching Reports Based on the Params = " + Params, detailedLogInfo.Result);
_logger.LoggingInformation("GetEmbedParams() => Update Parameters Method called", detailedLogInfo.Result);
var updateParametersRequest = new UpdateMashupParametersRequest
{
UpdateDetails = new List<UpdateMashupParameterDetails>
{
new UpdateMashupParameterDetails
{
Name = "Parameter Name",
NewValue ="Parameter Value"
}
}
};
pbiClient.Datasets.TakeOverInGroup(workspaceId, pbiReport.DatasetId);
pbiClient.Datasets.UpdateParametersInGroup(workspaceId, pbiReport.DatasetId, updateParametersRequest);
pbiClient.Datasets.RefreshDatasetInGroup(workspaceId, pbiReport.DatasetId);
}
EmbedToken embedToken;

if (isRDLReport)
{
_logger.LoggingInformation("Fetched report is RDL report", detailedLogInfo.Result);
embedToken = GetEmbedTokenForRDLReport(workspaceId, reportId);

}
else
{
_logger.LoggingInformation("GetEmbedParams() => Fetching embed token for the Power Report", detailedLogInfo.Result);
var datasetIds = new List<Guid>();
datasetIds.Add(Guid.Parse(pbiReport.DatasetId));
embedToken = GetEmbedToken(reportId, datasetIds, workspaceId, !Params.IsNullOrEmpty());

}

[Anonymous · Accepted solution]

Hi @Sabarish_Nandha ,

Please try below steps:

1. Navigate to Dataset Settings:
      Go to the Power BI Service (app.powerbi.com).
      Locate the dataset that is failing to refresh.
      Click on the "Settings" gear icon next to the dataset.

2. Update Data Source Credentials:
      In the dataset settings, find the `Data source credentials` section.
      Update the credentials for the data source(s) that are missing or have expired credentials.

3. Test the Credentials:
     After updating, make sure to test the credentials to ensure they are working correctly.

4. Updating parameters, and refreshing the dataset, If the credentials issue persists even after updating them in the Power BI Service, you may need to ensure that the service principal or the account used by the API has the necessary permissions to update the credentials.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.