Migrated database to new server - can we mass update our reports?

[Vegard1985]

Hi gurus,

We're currently migrating to a new database.

Does anyone have some good tips on how to get all our reports pointing to the new server. Anything in PBI Services we can make use of? Or do we actually need to go through each report manually and replace the datasources? Hope not..

95% of our reports are created with PBI Desktop and published to Services - a few reports has been created in Services - if that makes a difference. 

[amitchandak]

@Vegard1985 , refer if these can help

https://www.decisivedata.net/blog/change-a-power-bi-data-source-type

https://www.youtube.com/watch?v=mqoV-CRegp8

[Greg_Deckler · Accepted solution]

@Vegard1985 - You either need to go through each report and update or CNAME record in DNS. Or maybe the Power BI REST API.

[Vegard1985]

Thanks! We will most likely go down the CNAME road 🙂