Forum Discussion
We aim to update only the schema name in the Custom SQL-based Power BI Reports and Dashboards
Hello, We are facing a new challenge with updating over 200+ custom SQL-based Power BI reports that require a schema change in the power query. Is there an automated method to implement these change...
Vanchy_Liao
Advocate IV
Advocate IV
although the account/password indeed stored in sql server, i don't recommand you to update it by sql directly because it encrypt the password by certain mechanism.
you can use powershell or report server api to change credentials by script.
follow this document to use powershell
Thanks for the document, we aim to chage the existing SQL queries with the schema name directly.So i think this will not help to update the reporting queries.