dear support team,
we experience a strange behavior in PowerBI service. When a refresh of a dataset is scheduled, it fails. on the other hand, when the same dataset is refreshed manually, the refresh succeed.
here is a detail of the failed dataset log :
Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials",
"pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},
"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},
{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the PowerBI source are invalid. (Source at PowerBI.)"}},
{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind",
"detail":{"type":1,"value":"PowerBI"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"Web"}},
{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}},
{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"PowerBI"}},
{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessForbidden"}},
{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources",
"detail":{"type":1,"value":"[{\"kind\":\"PowerBI\",\"path\":\"PowerBI\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason",
"detail":{"type":1,"value":"AccessForbidden"}}],"exceptionCulprit":1}}} Table: Imputation_NC_DEV.
URI du cluster: WABI-WEST-EUROPE-redirect.analysis.windows.net
ID d'activité: 00000000-0000-0000-0000-000000000000
ID de demande: 6f1ff345-9445-4b00-9603-f1aeb092fe84
Heure: 2021-09-16 05:56:08Z
regards,
Bertrand Moser
4 Comments
- v-robertq-msft
Community Support
Hi,
According to the error message, it seems to be the data source credential error which leads to the refresh error. I think you can go the the dataset setting-> Edit credential to update all the credentials for this dataset and make sure they are correctly configured.
Best Regards,
Community Support Team _Robert Qin
why should I update the credentials since they work when the dataset is refreshed manually?
- v-robertq-msft
Hi,
If your dataset refresh only failed when it’s scheduled, I think it may be related to the scheduled refresh time of your dataset. If your interactive and background operations are too dense in the scheduled time, your dataset refresh will fail because of the lack of resources. I think you can try to set the refresh time to the free time like midnight and check if it can refresh successfully.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
