Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a scenario where I am dealing with too many data-driven subscriptions being required in order to generate EXCEL and PDF files on a repository.
According to the current configuration the report needs to execute twice for the same parameters in order to generate one EXCEL and one PDF.
My question is if there is a way to reduce the number of report executions per subscription taking advantage of the data being already in cache and just generate the two outputs EXCEL e PDF in one go.
Thank you
Regards,
LS
Hi, @djpirra ,
Your idea is great, but it requires modifying the system stored procedure of the report server database. If you're not clear about the logic here, it's not recommended, but you can create a copy on your local machine and do this test.
Best.
Hi DavisBI,
What stored procedure is that? Can you provide more details on what could be tweaked in order to support such scenario?
Regards,
LS
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |