From your description, you want to publish report and report data source to SharePoint site, right? If in this case, here has a sample script illustrates how to publish a report from a computer path to Reporting Services in SharePoint integrated mode. For
the detail information, please see: Publish report to Reporting Services in SharePoint Integrated Mode
If you have any questions, please feel free to ask.
If you have any feedback on our support, please click
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.