Forum Discussion
st586
6 years agoRegular Visitor
Using cmdlets to change SSAS connection in report
Hello World! I need a feature which I think isn't available, but I might be wrong. I want to use the Power BI cmdlets to repoint the datasource to a different database in the SQL Server Analysis Se...
Jayendran
6 years agoSolution Sage
Hi st586 ,
In Order to achieve your request you can use the Update Data Source API
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup
In order to automate either using Azure DevOps/ PowerShell I wrote an article which would helpful for you
https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244