Forum Discussion
Solved
Paginated report - modify connection
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
Hi Markzolotoy
Unfortunately you will have to go into each report and modify the connection and then re-publish/upload the reports.
4 Replies
GilbertQ So, I need to modify each report in the Report Builder and republish it?
Hi Markzolotoy
Unfortunately you will have to go into each report and modify the connection and then re-publish/upload the reports.
You could also try programmatically doing it with the rest API. https://docs.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources
