Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
W_G_Ryan
Helper I
Helper I

Determining Capacity for very large Report runs

I have a scenario where each month, we need to generate roughly 1 million reports (account statements),  We're using  Power BI Report Builder and they'll be exported to PDF where we will store them in Azure Blob Storage.  We've got the process working now for one subset of accounts, which amounts to about 3k a month, but they're executed on demand and not in batch.  

 

We have  a P3/A6 capacity but are trying to figure out if this is going to be enough. Obviously things start getting very expensive if you move up but we also need this to run and process as quickly as possible (right now, it's done on Prem which is notably faster and takes about 7-10 days).  

 

Has anyone run into scenarios like this, high volume report rendering (we only need the PDF if that matters)?  We're going to start load testing but our test environment doesn't have the same capacity as prod so that's going to take some orchestration, and also slighly worried that firing a huge volume of requests might look like a cyber attack of some sort and I'm just looking to get ahead and anything I can.

 

Any and all advice is greatly appreciated.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @W_G_Ryan 

 

What you could do is to rather spin up an Fabric Capacity when you want to run the reports on a monthly basis. When using the Fabric Capacity you can scale it up and scale it down as needed, as well as pause when not being used. So essentially. what that means is you could spin up a very large fabric capacity at the side of the month. let itrun through all your reports and then pause it or make it to a smaller capacity for the rest of the month.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Happy to help!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @W_G_Ryan 

 

What you could do is to rather spin up an Fabric Capacity when you want to run the reports on a monthly basis. When using the Fabric Capacity you can scale it up and scale it down as needed, as well as pause when not being used. So essentially. what that means is you could spin up a very large fabric capacity at the side of the month. let itrun through all your reports and then pause it or make it to a smaller capacity for the rest of the month.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hey there Gilbert:

 

That actually sounds perfect.  I thought you had to buy the capacity long term but that's awesome to know and definitely going to give it a try.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors