Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Report Server
imichalarias's avatar
imichalarias
Frequent Visitor
7 years ago

Is there any solution to this problem? We are trying to edit a PBIRS DataSource connecting to an on-premise SQL Server database, using the UpdatePowerBIReportDataSource method.

 

No matter what we edit (database name, server or user), we get a 400 bad request...

 

Our PBIRS is 15.0.1102.371 (Mai 2019).

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

  • imichalarias's avatar
    imichalarias
    Frequent Visitor
    7 years ago

    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...