SSRS - Auto Refresh of the Data Set Fields

Question

We have about 90 Report Builder Reports built by power users. These reports are built off the 20 odd Base reporting tables.

Once in a while we add new fields to these reporting tables.

The challenge here is to automatically refresh the Datasets in Report Builder (SSRS) without having to go through each report to manually refresh data on the data set. Since SSRS processes these reports with FMTONLY ON is there a way to automate this process dynamically.

Thanks

Answer 1

So, I think you should use report models A report model is made from a datasource view and once the DSV is updated, it reflects on the report model and consequently on all reports.

I dont think there is a way of doing it when the reports automatically connect to the DB