Power bi profile password changes

Hi. When the password change, you must reconfigure data sources. You should download and login at power bi desktop because the service portal doesn't care, it has its own credentials. When you change the password for service you need to think about the datasources involved and not the specific report.

Open "Manage Connections and Gateways" and the first tab contains all connections. Edit the sources affected. Change credentials. Once you change that, all refreshes using the source should be fixed.

I hope that helps,

Your solution is great ibarrau 

Hi, lea_313 

Power BI does not have a direct function to update this password. However, Power BI provides an API to update the gateway link credentials. You can call these APIs programmatically to quickly update the credentials.

First, here is the API you mainly call:

Gateways - Update Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Learn

It uses the patch method and then passes the parameters we need to update in the request body:

{
  "credentialDetails": {
    "credentialType": "Basic",
    "credentials": "{\"credentialData\":[{\"name\":\"username\", \"value\":\"john\"},{\"name\":\"password\", \"value\":\"*****\"}]}",
    "encryptedConnection": "Encrypted",
    "encryptionAlgorithm": "None",
    "privacyLevel": "None",
    "useEndUserOAuth2Credentials": "False"
  }
}

You mentioned that you have 40 gateway connection with the same credentials, you can set their datasourceId to an array variable, and then iterate through the entire array when sending a request. The official provides some code examples:

PowerBI-Developer-Samples/PowerShell Scripts/PatchDatasourceCredentials.ps1 at master · microsoft/PowerBI-Developer-Samples · GitHub

If you don't know the datasourceId of your gateway link, you can call the entire API below:

Gateways - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Get the API called by gatewayId:

Gateways - Get Gateways - REST API (Power BI Power BI REST APIs) | Microsoft Learn

After these few API calls, you have the gatewayId, datasourceId, and credentialDetails that need to be updated. You can then send a request to quickly update your credentials.

This is a quick method, but it requires some programming knowledge.

Solved: Manage password change for multiple reports - Microsoft Fabric Community

Best Regards

Jianpeng Li

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