Paginated report - modify connection

[Markzolotoy]

I have published reports working fine. The backend was changed and it's different SQL server now. I have about 20 reports. How can I fix all of them?

Thanks

[Markzolotoy]

@GilbertQ So, I need to modify each report in the Report Builder and republish it?

[GilbertQ]

Hi @Markzolotoy 

Yes because each report connection is linked to each report!

[GilbertQ · Accepted solution]

Hi @Markzolotoy 

Unfortunately you will have to go into each report and modify the connection and then re-publish/upload the reports.

[bradsy]

You could also try programmatically doing it with the rest API. https://docs.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources