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
pbiuser12345
Helper I
Helper I

Optimizing Report Builder Performance

Hello all,

 

I have build a paginated report in PBI Report Builder that pulls in data from a Power BI dataset, applies a filter, and then publishes a straight set of columns from the table.  The problem I am encountering is that even though the PBI dataset has fully loaded into my premium workspace, when I run the paginated report it appears to re-run the query.  The performance is abysmal because it needs to pull in 10M records before it filters down to the relatively few records I need (<10K records).

 

Is there a good resource that explains how the data model works for report builder?  I am not clear if this is following the dataset upstream to my DB and pulling from there (I cannot check the logs) or if it is really just taking forever to read in the table that is already in memory in my workspace.  If it's the latter, can I get away with creating a pre-filtered table in my PBI datasource and then it will only read in the ~10K records vs 10M?

 

Appreciate any advice you have for me!

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.