Forum Discussion
Update connection , dataset credentials Using Rest API
- 1 year ago
Hi
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
- Anonymous1 year ago
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
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