r/dataengineering • u/pusmottob • 13d ago
Help Need scheduled, parameterized reports (Excel/PDF/CSV) on Azure SQL + Power BI Pro. Where should I spend?
Current setup
Azure SQL Database (Standard S2, DTU model). No linked servers or cross-database queries.
Power BI Pro for dashboards (40 users, 3 authors).
We have no tool for scheduled or paginated reports, and no SQL Server licenses or Fabric capacity.
What we need
Automated Excel, PDF and delimited-text (CSV/pipe/tab) reports
Delivery by email and to a network share drive (SFTP would be a bonus, but we can move files with external processes)
Parameterized subscriptions, with a large list of them managed from a table, like SSRS data-driven subscriptions
About [N] reports and [N] recipients, mostly monthly
Background
At past jobs we used SSRS or Crystal Reports, and SSRS would fit. But SQL Server 2025 shipped without it (2022 is the last version), and Power BI Report Server replaces it. We don't own SQL Server, so a license would be a new $8k spend just to host reporting. I can only fund one path.
Options I'm weighing
Fabric F2 (1-year reserved, about $1.9k/yr), scaling to F4 on report days. Power BI paginated reports plus subscriptions. As I understand it, delivery goes to email and OneDrive/SharePoint, and per-recipient dynamic subscriptions are email only. For file shares and bulk parameterized runs I'd need to build something with Power Automate, Logic Apps or the Export API.
SQL Server 2025 license (about $8k) to run Power BI Report Server. On-prem, with data-driven subscriptions and file share delivery. Needs a server to host it.
A third-party scheduler (PBRS or similar) on top of Power BI.
Questions
Has anyone built SSRS-style data-driven subscriptions on Fabric paginated reports plus Power Automate or the Export API? How did it hold up (throttling, timeouts, failures)?
Can an F2/F4 handle paginated report exports from an S2 Azure SQL database without throttling?
When scaling a reserved F2 up to F4 for a few days each month, how is the extra billed?
Can the CSV delimiter be controlled in paginated report exports?
For a small team with this budget, which option would you pick, and what would you avoid?
Thanks in advance.
2
u/SQLDevDBA 13d ago edited 12d ago
A few options here.
You can try Paginated reports right in the service. They’re available in Pro. You can subscribe to these and have the attachment come via emails as excel. You can’t export as CSV in the service via subscription. They usually recommend PBIRS for that.
Power BI report Server. This will probably get you across the finish line with a single non-code solution. You can connect to Azure SQL with no issues, make pixel perfect paginated reports that go to PDF, excel, CSV, etc and do allow SFTP as a destination (as well as email, file system, etc.). Scheduling is super easy to set up and manage. https://www.microsoft.com/en-us/microsoft-fabric/features/power-bi/report-server
SSIS with a 3rd party toolset like KingswaySoft. They have advanced tasks that allow you to export data to excel, CSV, etc and also integrate with any SFTP Providers. Free for development purposes. https://www.kingswaysoft.com/products/ssis-productivity-pack
Python or powershell. Powershell is my preferred over python, but both work and are similar. Powershell has https://DBATools.io which is amazingly fast since it uses SQLBulkCopy. I use it for 90% of my ETL nowadays.
If I was given the platinum card, I’d go with Power bi report server. It would be a single place to manage it all (reports, exports, scheduling).
You can probably vibe code something as well. But for sustainability I’d go with PBIRS or similar.
1
u/pusmottob 12d ago
Right, this is my choice, buy SQL Server to be able to use SSRS or subscribe to Fabric. Currently i have neither.
It sounds like you are thinking go with Fabric and forgetting SSRS. Which is how i am leaning.
2
u/SQLDevDBA 12d ago
SSRS Is no longer offered with SQL Server 2025. It is now Power BI Report server.
If you want to try it out, you can install sql server developer edition for free, and power BI report server developer edition for free as well. Make sure you use developer and bot evaluation edition. You can install both on a cloud or on-prem server and try out the features of a PBIRS to see if they fit your needs.
1
u/pusmottob 12d ago
I see, thank you, my research had initially shown it was still available until 2033. It sounds like the best bet would be fabric on demand and disable it on-off hours. The question then becomes is F2 feasible? My thought is F2 MF during work hours and on first of the month when all the reporting occurs scale to F4 for a few hours.
2
u/SQLDevDBA 12d ago
It’s still supported but starting with 2025 it is no longer offered. PBIRS took over.
I don’t know enough about fabric to know if it’s feasible for you. All I can say is if it were me I’d give PBIRS a try since it’s free for POC/Dev. I’ve implemented it 3 times and it has worked out well.
1
u/pusmottob 12d ago
I think this is the only option now. I am looking into a 60 day trial on f2 to see if i need to pitch f2 or f4
2
u/sxpn69 13d ago
Paginated reports are ssrs reports. Use dynamic subscriptions where you can. Use pipelines for the rest if it's critical somehow. Highly unlikely you would need to scale an f2 up just for ssrs reports, do fabric mirroring on your DB and query from fabric.
1
u/pusmottob 12d ago
Right, this is my choice, buy SQL Server to be able to use SSRS or subscribe to Fabric. Currently i have neither.
1
u/sxpn69 12d ago
I'd go f2 capacity, pay as you go, if it's not anything you need frequently you can even pause it, but it's ~200$/mo and if you leverage mirroring to your DB, storage and compute on that are free, so you are only covering compute on some likely light queries to generate the report, worst case, do some ETL on the data daily to spread the computation across the week.
1
u/pusmottob 12d ago
I see, thank you, my research had initially shown it was still available until 2033. It sounds like the best bet would be fabric on demand and disable it on-off hours. The question then becomes is F2 feasible? My thought is F2 M-F during work hours and on first of the month when all the reporting occurs scale to F4 for a few hours.
1
u/tech4ever4u 11d ago
Automated Excel, PDF and delimited-text (CSV/pipe/tab) reports
Shameless plug here: take a look at SeekTable (on-prem / affordable fixed price) which has 'subscribe to report', web API for parameterized exports to CSV/Excel (with colors formatting)/PDF, multi-tab Excel exports are present. SSRS-like data-driven subscriptions are supported with "Advanced email subscriptions" option. Disclaimer: I'm affiliated with this product (feel free to PM me).
1
u/Bitavu 6d ago
I've worked with Crystal Reports, Telerik Reporting, SSRS and others and managed/migrated hundreds and hundreds of reports with generating thousand of reports a month. How important is it for your team to handle PDF, Excel, and CSV in one tool? If you're open to splitting out PDF rendering, the stack your analysts maintain could handle the Azure SQL queries, per-recipient parameters, scheduling, Excel/CSV exports, and delivery.
I'm building Bitavu, a visual PDF template editor with a rendering API. For reports without PHI, the hosted API renders in memory with zero retention of the JSON payload and generated PDF. We're also exploring an optional self-hosted renderer that could run inside your approved environment and keep the render data and output there (ePHI, BAA).
If either option fits what you're evaluating, I'd be happy to mock up one report with synthetic data and show where the PDF step would fit into a scheduled run.
1
u/codegato 5d ago
Disclosure: I work for Codegato, so this is a vendor answer.
You do not need F2 for this. Power BI Premium Per User (PPU) is enough to run paginated reports, and our tool handles the rest: data driven jobs, Excel, PDF and CSV output, and delivery by email, network share, SFTP or SharePoint.
We also support other report types, and you can mix reports and merge the outputs.
Here is a 4 minute video if you would like to see it: https://youtu.be/uHMEklPSaSU
I am happy to answer any questions.
1
u/christiansteven 4d ago edited 4d ago
I don't want to self-promote, but I can't help but bring up that everything you want can be done for $3k a year using a third party tool called PBRS by ChristianSteven Software. You won't need a SSRS installation; you won't need Fabric capacity; you'll get Data-driven scheduling just like the old SSRS days; Excel, PDF & CSV outputs just as you want; Email, Network folder and SFTP delivery as per your requirements; and a dedicated scheduler means you don't have to maintain separate, retry and delivery processes. And, yes, the CSV delimiter can be controlled. https://go.christiansteven.com/power-bi-report-scheduler.
1
13d ago
[removed] — view removed comment
1
u/dataengineering-ModTeam 13d ago
Your post/comment was removed because it violated rule #9 (No AI generated content/text).
Your post/comment was reviewed to be AI generated/assisted content/text and removed as a result. We as a community value human engagement and encourage users to express themselves authentically.
This was reviewed by a human
9
u/ImpressiveCouple3216 13d ago edited 13d ago
Similar requirements in my company are addressed using custom python jobs that extract data out of the source, apply necessary transformations and format in PDF or Excel. Then send over mail or send to sharepoint using MS Graph API. The jobs run in a a separate Prefect Orchestrator, but it could be Airflow, cronjobs, windows task etc. We also have Fabric F64 but not used for these kind of data delivery, although it is possible using a notebook in Fabric.
For parameters, either users use Power BI semantic model in Excel, or we usually built a custom page inside the firewall, with azure SSO, where users can enter data into a form and that triggers the jobs. We built those pages using Streamlit before, now all of those applications are being migrated to next.js but functionality is same.