When you select the Reporting Services option, you can create a data source from a Reporting Services report.
.png)
Server Path
Enter the path to the Reporting Services server and click Connect.
SharePoint Site
Select the SharePoint site where the reports are located.
Reports
From the dropdown list, select a report.
Report Snapshots
Click on the Report Snapshots tab and select a snapshot.
If you want the snapshot to refresh every set amount of time, specify the number of minutes in Invalidate Data Cache After.
Report Parameters
Click on the Report Parameters tab to define the parameters to pass to the view.
.png)
Click Edit .png){kind=small}
to open the Manage Parameters dialog box.
Click the Add .png){kind=small}
button. Enter the parameter name and the default value. Repeat this for each additional parameter. Click OK.