topic Re: High Volume Report Export in Report Server

High Volume Report Export

LostHighway72 — Mon, 06 Sep 2021 16:28:07 GMT

Hi There,

I have a requirement to develop a solution to generate approximately 6,500 reports within a 2 hour processing window, and then export the reports in either PDF or Excel format to a secure ftp site. The source is SQL and the report data is from stored procedures. Currently this is being handled with Crystal reports, so I am hoping that Power BI might be a suitable alternative. The reason I am posting in this forum is that the data is sensitive and has to handled On Prem, hence why we are looking at our own Power BI Server.

Any thoughts or feedback would be gratefully received.

Thanks in Advance

Re: High Volume Report Export

ponnusamy — Tue, 07 Sep 2021 16:14:57 GMT

Hi LostHighway72 : As far as I know , you can not subscribe (email) or send the reports to 'windos file share' from "Power BI Report Server". It will be able to generate reports that you would need and you can keep the entire setup on prem but you can not export the reports in PDF or Excel to a secure FTP Site directly from Report server. There are quite a good number of features available on cloud based "Power BI Service" are not available on on-prem 'Power BI Report Server'.

Re: High Volume Report Export

LostHighway72 — Tue, 07 Sep 2021 16:36:14 GMT

Hi There,

Thanks for the response. The data is senstive and therefore has to stay on prem. One train of thought is to use email as a delivery mechanism. But from research there appears to be limits to the amound of reports that can be processed every hour?

And any idea what scale of server would be required to handle the volume in a short processing window?

Thanks again

Re: High Volume Report Export

ponnusamy — Tue, 07 Sep 2021 16:44:49 GMT

I believe the "Report server" does not support email functionality. Are you referring to some other tool to send emails?