Forum Discussion

Wendeley-North's avatar
Wendeley-North
Resolver I
5 years ago

PowerBI Scheduled Refresh Error - Failed to Update Data Source Credentials (Python)

Hi, trying to set up a scheduled refresh for my dataset, and running into the following issue when I try to update my credentials for the Python script that my report is using as a datasource: ...
Need Help
ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. The problem here is that there is a limitation in the standard/enterprise gateway. You can't handle Python or R with that gateway. You must use the "Personal" mode of the gateway to refresh a model using Python scripts. That gateway won't ask for credentials.

If that is set and you continue having errors, be sure that your developer environment is almost the same as the gateway environment (python version, libraries, packages, etc). You can always try refresh PBI Desktop in the same VM of the gateway to check for errors.

I hope that helps,

  • Wendeley-North's avatar
    Wendeley-North
    Resolver I
    5 years ago

    Hi, I am currently using the personal mode of the gateway, as far as I can tell - is there anything in the error message that indicates otherwise? And yes, I've been able to refresh the report in on the PBI Desktop, but not in the web service.