How to change the name of database server in multiple reports?

Power BI
1

Hi everyone,

The IT team have changed the name of our SQL database server and now we need to update the new database name in all the reports that use this database server as source.

It´s a big number of reports (more than 50) and we would like to check before doing manually if there is an easier way of doing that, anyone know?

And also if there is a best practice to follow to avoid this problem in the future.

Thanks a lot,

Hugo Costa

2

Hi @hugo.costa. Not AFAIK.

If all your reports are “thin” reports and use a Power BI dataset, the you can edit the PBIX for the dataset(s) or adjust its (their) server and database name parameters in the Power BI Service.

If all your reports use parameters for the server and database name, then you should be able to do this in the Power BI Service only, editing the configuration for each report individually.

If you’re not using parameters for the server and database name, then you’ll likely need to edit the PBIX file for each report individually and republish.

Not what you wanted to hear, I’m sure …
Greg

1 Like
3

Hi Greg!

Thanks for your reply.

I was expecting that, but you gave me a good tip to improve and use the parameters. :slight_smile:

Best regards,

HC

4

Hi @hugo.costa,

I hope that you are having a great experience using the Support Forum. Please don’t forget, if your question has been answered within the forum, it is important to mark your thread as ‘solved’. We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey, We hope you’ll give your insights on how we can further improve the Support forum. Thanks!

5

Hi @hugo.costa, due to your inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.