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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
IngloriousJu
New Member

Migrated SSRS Report to Paginated Report with List Control - Performance Difference

Hi Everyone

 

We are migrated a large number of client reports over to Power BI from our SSRS legacy system. So far we have had no issues, until we get to a particularly tricky report that one client requested, with very specific requirements for a pixel perfect PDF exportable report. In the original SSRS report, we have a list control for one group. Within that list is a subreport, which has its own list for another group and then within that a final subreport with its own list. Whilst not a great way of producing the report, the clients wants a single report to produce the layout for the various groups. Its only run once a quarter.

 

The issue we have is the report does not run in Power BI but does in SSRS. The SQL code has been optimized and runs within a couple of seconds for each iteration of the groups. What I noticed yesterday when running the report in Power BI, the pop-up that appears showing the records processed, it started of super quick for what I think is each iteration, it slowed down each time. I left the report running for 1 hour 45 minutes before cancelling it. The SSRS version takes 38 minutes, which I know is obscene but it works.

 

So my question is, how does Power BI handle the data coming in for the list control, as it appears to be doing something different to what SSRS would do. Sorry if this is really confusing. Or if anyone has any suggestions on how better to produce a paginated report with multiple levels of grouping\looping, that would be great.

2 REPLIES 2
IngloriousJu
New Member

Unfortunately, none of those links has any information on my issue or question. But thanks anyway.

v-rongtiep-msft
Community Support
Community Support

Hi @IngloriousJu ,

Please refer to the following links:

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors