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