PBIRS extracts to Sharepoint or FTP

[Omega]

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. 

[FarhanAhmed]

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-subscription...

Regards

[Omega]

Hi, 

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

Thanks!

[d_gosbell · Accepted solution]

---

@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.