High Volume Report Export
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