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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
DarkModePleez
Frequent Visitor

How to pre-cache (in the background) a Python visualisation on filtered data

Hi,

I'm using a Python visual in a report. It's a ggplot2 linechart with several graphs/curves. There are slicers in the report. When I open the report in Service, the first time I use the slicer to filter data it takes 5-10 seconds for the Python visual to compute. If I unselect and reselect the same filtering, it takes about half a second. Why? How to make it take half a second the first time?

In my understanding, the report runs the Python script the first time I use the slicer, then caches the data and uses the cached data the second time the filtering is chosen. Is there a way to make PowerBI precalculate and cache a selection/filtering on data? IS there a way to make PowerBI load Python script runs in the background? 

1 REPLY 1
lbendlin
Super User
Super User

No, that is not currently possible. The queries for the visuals on a page are only run when the visual is rendered.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.