topic Re: PBIRS extracts to Sharepoint or FTP in Report Server

PBIRS extracts to Sharepoint or FTP

Omega — Sun, 20 Sep 2020 13:17:50 GMT

Hi,

I have SSRS reports that are scheduled as .csv and excel to my email on daily basis. I want to schedule these reports to be available on Sharepoint or FTP. I managed to do so using Microsoft Flow by creating a flow that picks the attachments from my email and push to the FTP and Sharepoint.

I am looking for alternative to push the extract from PBIRS (Power BI Report Server) directly to Sharepoint or FTP as the extracts are becoming larger and it takes more time to receive the email.

Please help.

Re: PBIRS extracts to Sharepoint or FTP

FarhanAhmed — Mon, 21 Sep 2020 09:19:26 GMT

Hi Omega ,

Kindly check the below article and see if this resolve your issue

https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/create-and-manage-subscriptions-for-sharepoint-mode-report-servers?view=sql-server-ver15

Regards

Re: PBIRS extracts to Sharepoint or FTP

Omega — Mon, 21 Sep 2020 12:40:32 GMT

Hi,

I can't create UNC for my sharepoint and I need a way to connect to SFTP as well. Any ideas?

Thanks!

Re: PBIRS extracts to Sharepoint or FTP

d_gosbell — Mon, 21 Sep 2020 22:39:42 GMT

Omega wrote:

I can't create UNC for my sharepoint and I need a way to connect to SFTP as well. Any ideas?

Subscriptions only support email and windows file shares. So if you cannot create a unc for sharepoint and you also need to support SFTP the only choice I can think of is to write a script using something like powershell that will run the report to generate your files locally and then push out to Sharepoint and/or SFTP.

You can use url access to export a copy of your report and you should be able to use a method like one of the examples here https://blog.jourdant.me/post/3-ways-to-download-files-with-powershell to download the file from that url. And you should be able to google and find examples of how to upload files to Sharepoint and SFTP.

Then it would just be a matter of using something like a SQL Agent job to schedule a script like this.