Forum Discussion

salmon's avatar
salmon
Microsoft Employee
6 years ago

Python personal gateway credentials, A problem occurred while processing your Python script.

I was trying to schedule the refresh of power bi report, but got an error concerning invalid credentials 
(Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.). 

 

The power bi report can run normallu on my pbi desktop. The other data sources connect fine through the personal gateway. When I click on 'Edit Credentials' for Python, I get the following specifics:

Failed to update data source credentials: ADO.NET: A problem occurred while processing your Python script. Here are the technical details: Access is denied.

Need Help

7 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi salmon ,

     

    1. Please refer the following trouble shooting:

    Error: The credentials provided for the dataset are invalid. Please update the credentials through a refresh or in the Data Source Settings dialog to continue.

    If you get a credentials message, it could mean:

    The usernames and passwords that you used to sign in to data sources aren't up to date. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

    This error is a known issue, and it's being looked at. To work around the problem, have a separate query for the cloud source and the on-premises source. Then, use a merge or append query to combine them.

     

    Please refer this article: Troubleshooting Power BI gateway (personal mode)

     

    2. Or from the Data Source Settings dialog, select the data source(s) and then select Edit Permissions... and ensure that the Privacy Level is set to Public.

     

    3. Please update the gateway to the latest version, and install the on-premises data gateway (personal mode) on the same machine as Python directory.

     

    4. If it doesn't meet your requirement, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

     

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • salmon's avatar
      salmon
      Microsoft Employee
      6 years ago

      Thanks for reply, but I have all my dataset privacy level to be public, I think the problem may be from the processing python script? while I can run normally in my local machine.

       

    • salmon's avatar
      salmon
      Microsoft Employee
      6 years ago

      Is there any other way I can contact to the technical support, I am an emploee of Microsoft, but not a pro user to create the ticket.

  • tqloc's avatar
    tqloc
    New Member
    4 years ago

    I was trying to refresh of power bi report, but got an error concerning invalid credentials
    (Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.).
    The power bi report can run normally on BI. The other data sources connect fine through the personal gateway. When I click on 'Edit Credentials' for Python, I get the following specifics:
    Failed to update data source credentials: ADO.NET: A problem occurred while processing your Python script. Here are the technical details: Access is denied.

    Please give me some support!!!!