Moving Servers - Need to change all data source connections in PBI reports

[KarenFingerhut]

Hi there

I have a suite of PBI reports all pointing to one server.  However, we are now changing servers and I need to point all my PBI reports this new server (has a different server name - all DB's in there have the same names as the current server)

Rather than have to go in to each PBIX file individually, change the data solurce and republish is there any way I can do this en-mass or is it individual way only.

Any help would be really appreciated

Many thanks

Karen

[Greg_Deckler · Accepted solution]

@KarenFingerhut If it was done in each PBIX then you have to change each one. This scenario is the purpose of dataflows. If this had been done with a dataflow and each PBIX used that dataflow then you would have a single place to change it.

[KarenFingerhut]

Ah **bleep**, thanks Greg. Lessons learnt

Kind regards

Karen