Paginated report (power bi report builder) take along time to fetch data

[amal_01]

I created a power bi report builder
I used a sample query to get data from one table  

EVALUATE SUMMARIZECOLUMNS( 'InventRepriceJourTransEntity'[ItemId], 'InventRepriceJourTransEntity'[BarCodeString], 'InventRepriceJourTransEntity'[dataAreaId], 'InventRepriceJourTransEntity'[InventSiteId], 'InventRepriceJourTransEntity'[JournalId], "TotalAmount", SUM('InventRepriceJourTransEntity'[Amount]) )

When I run this query in DAX Studio, it takes 17 seconds.
But when I run it in Power BI Report Builder, it takes 2 minutes and 45 seconds.

Where is the issue?
Is Report Builder naturally slower, or is there something wrong with my query or the Report Builder settings?

[v-priyankata · Accepted solution]

Hi @amal_01 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Power BI Report builder is little slow than DAX studio because when you run a query in DAX Studio, it just gets the data but when you run the same query in Power BI Report Builder it builds the full report like arranging the rows into tables, formatting, figuring out how everything fits on each page. That’s why the same query takes only 17 seconds in DAX Studio but much longer 2 mins in Report Builder. The delay is not due to the DAX query but due to the rendering and formatting work that Report Builder does after the query completes.
Please refer to the document below, it may helps you.
Page layout and rendering in Power BI paginated reports - Power BI | Microsoft Learn

Thanks.

[v-priyankata]

Hi @amal_01 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @amal_01 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @amal_01 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted  If yes, marking the relevant solution would be awesome for others who might run into the same thing.