Server Upgrade

amandabus21 — Wed, 18 Sep 2024 19:59:06 GMT

We are doing a server upgrade and moving ourSQL Server databases to another server.

I have all my reports pointing to the old database. Is there a way i can globally change the datasource to point to the new server? Instead of manually opening each report and changing the datasource in Power BI Desktop.

Re: Server Upgrade

Anonymous — Thu, 19 Sep 2024 02:45:16 GMT

Hi, amandabus21

Thank you for your inquiry. You mentioned that you need to change the data source of your Power BI reports, which is a very common need. However, due to limitations on the Report server, we are unable to modify our connections strings.

Here the official offers a working solution:

Change data source connection strings with PowerShell - Power BI | Microsoft Learn

First we need to create a parameter for our connection string in PowerQuery, and use the parameter when connecting:

Next we need to use the PowerShell tool to update the data source connection string for our report:

To use this method, you need to have a solid understanding of how Report Server uses PowerShell and how to use PowerShell to traverse your reports.
Bulk updates can be achieved by iterating through all reports and executing the update connection string cmdlet command provided by the document.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Server Upgrade in Report Server

Server Upgrade

Re: Server Upgrade