Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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());
}
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
40 | |
27 | |
25 | |
23 | |
21 |
User | Count |
---|---|
56 | |
32 | |
23 | |
22 | |
20 |