Drill down with Report builder paginated report - Data Retrieval

[raneetha]

Hello Experts ,

  We are using Report Builder Paginated reports for the first time . Our report use the drill down capability .

In the drill down report data rertrieval happens at the time of each user click or at the time of main report load ?

Currently it takes a long time after each exapanse / collapsing .. . Any insights would be greatly appreciated 

[Anonymous · Accepted solution]

Hi @raneetha ,

What kind of connection mode did you choose when your Report Builder connected to teradata server, Import or Direct Query? 

If you choose Direct Query, it will only load metadata into Report Builder. When your end user do some interactions to your report, like click or drill down as you mentioned, Power BI will send the query to your datasource. If there is a large amount of data in your data source, this may cause long time to get the result by query. But Direct Query will take up only a little memory due to it only load metadata.

If you choose Import, you will load all data from teradata server to Report builder. If you have a large amount of data, this will take up your large amount of memory. However, the performance of Data Retrieval will be faster.

For reference: About using DirectQuery in Power BI

Best Regards,
Rico Zhou

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

[parry2k]

@raneetha what is your data source? 

[raneetha]

@parry2k  its our teradata server .