Change data source for mutiple datasets at once

Hi All,

In the BI development studio when I have to change the data source for data sets within a report, I have to go to each of the datasets individually to do this. Is there a quicker way to do this. Say I want to change data source for the entire report in BI dev studio.

thanks

Sonny

Use shared data sources across the reports.

Then you will only have to change the data in the data source and not the datasets.

This will automatically be reflected in the IDE.

Obviously this will not be updated on the report server until you redeploy, be aware of the project based setting "OverwriteDataSources" when deploying!|||

thanks Adolf , that helped.

sonny

Change data source for mutiple datasets at once

Hi All,

In the BI development studio when I have to change the data source for data sets within a report, I have to go to each of the datasets individually to do this. Is there a quicker way to do this. Say I want to change data source for the entire report in BI dev studio.

thanks

Sonny

Use shared data sources across the reports.

Then you will only have to change the data in the data source and not the datasets.

This will automatically be reflected in the IDE.

Obviously this will not be updated on the report server until you redeploy, be aware of the project based setting "OverwriteDataSources" when deploying!|||

thanks Adolf , that helped.

sonny