Changing IP and Name of Database

[RanHo]

Good day!

I just wanted to ask if we're going to change the IP of our Database source(transfer database) and Database name that is already imported in my Report/Dashboards , what will be the requirements needed to ? Is it going to affect all my reports? Or im going to reconfigure it one by one? Any advice?


Thanks in advance.

[Anonymous · Accepted solution]

HI @RanHo,

Did the new data source have the same data table structure as the old one? If that is the case, you can simply change them on the power bi desktop site and publish the report to update the new versions with corresponding configurations.

In addition, you can also take a look at the following blog about parameterizing your connection string with query parameters then you can change them to update the datasourcce connection on the power bi service side .

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev 

Regards,

Xiaoxin Sheng

[amitchandak]

@RanHo , You can change the source connection setting under data source (Transform Data).

Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

For each table you also do it individually