topic Re: Update connection , dataset credentials Using Rest API in Service

Update connection , dataset credentials Using Rest API

Dimitris_Kats — Sun, 12 Jan 2025 16:45:41 GMT

Hello dear members,

I hope you are doing well.

Every 90 days there is a company policy to change our passwords. Every time we need to update manually power bi connections.
Is there a way to use Rest Api to update the credentials programmatically? Ususally the data source is a cloud service like Aure and not on prem.
If not is there any other way to achieve that?

Thank you in advance

Re: Update connection , dataset credentials Using Rest API

GilbertQ — Sun, 12 Jan 2025 22:52:26 GMT

Have you looked at using a service principal account where the password only expires every two years? This will allow you to not have to change the password every 90 days.

Enable Service Principal Authentication for Read-Only Admin API’s
Create an Azure AD app
- Ensure there are no Power BI admin-consent required permissions on the application
- Create a client secret / key and copy the value for later use
- Create a new Security Group in AD, add the app to the group
- Enable Allow Service Principals to use read-only Power BI admin API’s in the Power BI Tenant

Dimitris_Kats

Re: Update connection , dataset credentials Using Rest API

Dimitris_Kats — Mon, 13 Jan 2025 07:18:52 GMT

Thank you so much GilbertQ
This is very helpful. I will investigate that option for sure.
Since I was requested to update the credentials using Rest Api, I was wondering if this is possible and how.

Thank you so much again 🙂

Re: Update connection , dataset credentials Using Rest API

Anonymous — Wed, 15 Jan 2025 12:41:58 GMT

Hi Dimitris_Kats,

Thank you for reaching out to Microsoft Fabric Community Forum.

Please refer to the document below for instructions on updating dataset credentials programmatically.

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"

Regards,

Vinay Pabbu

Regards,
Vinay Pabbu

Re: Update connection , dataset credentials Using Rest API

Anonymous — Wed, 22 Jan 2025 11:41:00 GMT

Hi Dimitris_Kats,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Vinay Pabbu

Re: Update connection , dataset credentials Using Rest API

Anonymous — Mon, 27 Jan 2025 16:20:16 GMT

Hi Dimitris_Kats,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

Vinay Pabbu

Re: Update connection , dataset credentials Using Rest API

Anonymous — Fri, 31 Jan 2025 14:15:15 GMT

Hi Dimitris_Kats,

Regards,
Vinay Pabbu

Re: Update connection , dataset credentials Using Rest API

Amy007 — Fri, 14 Feb 2025 14:11:50 GMT

Yes updating credentials is possible using the new Update Connections api ,It works for Power BI.

ShareableCloud connection Connections - Update Connection - REST API (Core) | Microsoft Learn