Pause visuals from loading

[RossS]

Is there a way to pause visuals from loading? I have a team using a report that consists of a large table visual. They scroll down the table, move away from that report page, and when they move back to it the table loads again and starts at the top.

I have tried selecting Optimize - Pause visuals in desktop, but this doesn't work. 

[v-pnaroju-msft]

Hi @RossS,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @lbendlin, @krishnakanth240, @cengizhanarslan, and @Wikkleyn_81  for your responses.

Hi RossS,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solutions provided by @lbendlin, @krishnakanth240, @cengizhanarslan, and @Wikkleyn_81 to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[Wikkleyn_81]

Hi @RossS One option we use for a large table visual is to only show data when the user makes a slicer selection. 

Steps to Implement:
Create a Filter Measure: ShowVisual = IF(ISFILTERED('Table'[Column]), 1, 0)
Apply to Visual: Drag this measure into the "Filters on this visual" pane and set it to is 1.

[cengizhanarslan]

Power BI re-renders visuals every time you navigate back to a page, and there is no native setting to preserve scroll position between page navigations. The Pause Visuals option in the Optimize ribbon is a development tool for pausing rendering while authoring, not an end-user feature.

Option 1) As an alternative you couls try using paginated report instead.

Option 2) Build table page navigation buttons as described below video:

https://www.youtube.com/watch?v=TiS6vnju_mI 

[krishnakanth240]

Hi @RossS 

We cannot pause visuals for end user interaction or preserve scroll position. Optimize - Pause visuals works only for design time authoring but not for user navigation behavior and does not persist after page switch.

So, Desktop workaround is to reduce table size by applying filters / Top N and avoiding long scrolling tables. Using drillthrough instead of page switching.

[lbendlin]

The only option is the delayed apply button.