Forum Discussion
Powershell script to change Datasource Test to Production
Does someone have a powershell script to change the data source? For example I want deploy my report to powerBI reporting service from Test to Productios therefore i need to change the datasou...
To my knowledge, it is only possible with SSAS-based sources. It's certainly not possible with SQL Server databases.
You're able to attempt this with your report by: "Manage"-->"Data sources"-->"Connection string". Try to edit the connection string. It's possible in SSAS but nothing else I've ran into.
Anonymousthanx for the quick reply! I have no clue (and no understanding) why this function is limited to SSASconnections only... What were they thinking??? Let's hope it is going to be fixed soon...