Forum Discussion
Update connection , dataset credentials Using Rest API
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
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
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
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 🙂