Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
We have around 40 individual power bi reports with various data sets that have been built with example@microsoftaccount.com
When we change the password for example@microsoft it breaks all of the refreshes scheduled on the reports. I then have to download them all individually, sign in and re-publish the report. This takes hours
How can I update the password linking to all of these reports in one go?
Each report has its own data set, some of the data sets at the same.
Thanks
Solved! Go to Solution.
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,
Happy to help!
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:
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.
Hi
Thanks for the suggestion, this definitley looks like a quicker solution
I still have about 40 different connections to update though, they all use the same credentials. Is there any way to update all the connections in one go? Or do I have to go line by line?
Thanks again
Leanne
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:
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.
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,
Happy to help!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
14 | |
8 |
User | Count |
---|---|
49 | |
39 | |
32 | |
16 | |
14 |