- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PBIRS extracts to Sharepoint or FTP
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Omega ,
Kindly check the below article and see if this resolve your issue
Regards
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I can't create UNC for my sharepoint and I need a way to connect to SFTP as well. Any ideas?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-16-2025 05:44 PM | |||
11-19-2024 05:57 PM | |||
10-14-2024 02:12 AM | |||
07-27-2021 07:47 AM | |||
08-22-2022 06:33 AM |